常用SQL语句备查

更新字段

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

批量插入行

INSERT INTO table_name (column1, column2, ...)
VALUES (value1a, value2a, ...),
       (value1b, value2b, ...);

批量删除行

DELETE FROM table_name WHERE id IN (11,12);

末尾增加列

ALTER TABLE table_name
ADD column_name datatype;

修改表名

ALTER TABLE table_name RENAME TO table_name_new;