语法#
UPDATE table_name
SET column1 = value1, column2=value2..., columnN = valueN
WHERE [condition];
实例#

UPDATE COMPANY SET ADDRESS = 'Texas' WHERE ID = 6;

UPDATE COMPANY SET ADDRESS = 'Texas', SALARY = 20000.00;

UPDATE table_name
SET column1 = value1, column2=value2..., columnN = valueN
WHERE [condition];
UPDATE COMPANY SET ADDRESS = 'Texas' WHERE ID = 6;
UPDATE COMPANY SET ADDRESS = 'Texas', SALARY = 20000.00;
本文标题:sqlite(10)-Update语句
本文链接:https://www.haomeiwen.com/subject/qicpdttx.html
网友评论