(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);
}