sqlite-update

发表于 2019-08-14 更新于 2020-04-13 分类于数据库阅读次数：本文字数： 212 阅读时长 ≈ 1 分钟

UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];


UPDATE table
SET column_1 = new_value_1,
    column_2 = new_value_2
WHERE
    search_condition 
ORDER column_or_expression
LIMIT row_count OFFSET offset;