sqlite(10)-Update语句
2016-06-15 本文已影响0人
Flannery
语法#
UPDATE table_name
SET column1 = value1, column2=value2..., columnN = valueN
WHERE [condition];
实例#
实例
UPDATE COMPANY SET ADDRESS = 'Texas' WHERE ID = 6;
实例2
UPDATE COMPANY SET ADDRESS = 'Texas', SALARY = 20000.00;
实例
