1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| INSERT INTO 表名 (列1, ...) VALUES (值1, ...);
INSERT INTO 表名 (列1, ...) VALUES (值1, ...),(值1, ...)...;
UPDATE 表名 SET 列1=值1, 列2=值2, ... WHERE 条件;
DELETE FROM 表名 WHERE 条件;
SELECT * FROM 表名;
SELECT * FROM 表名 WHERE 条件;
SELECT * FROM `Articles` WHERE `id`>2 ORDER BY `id` DESC;
|