Sqlite数据更新update

（1）单表内字段更新

update PipeLine set state='0' where Address='33'

（2）两个表间单字段关联更新

     sql = "update Videos set 
                 ID =(select ID from TMPLINETotal  where Videos.Lno=TMPLINETotal.Lno ) ";

（3）多字段更新
                    sql = "update ResultRecord set

 Score=(select Score from DefectGrade  where ResultRecord.D_GradeCode=DefectGrade.FCode), 

Remark=(select FName from DefectGrade  where ResultRecord.D_GradeCode=DefectGrade.FCode )";

（4）为已有表新增字段

   sql = "select * from Videos limit 0,1";
   DataTable VideosDt = ExecuteTable(sql);

   var isContainS_Exp = VideosDt.Columns.Contains("S_Exp");
    if (!isContainS_Exp)
      {
            sql = "alter table Videos add column S_Exp char(50)";
            ExecuteNonQuerySqlite(sql);
    }