INSERT INTO table(x) VALUES(?)
x为列名,?为要插入的值。
DELETE FROM table
WHERE (xx);
where后的条件最好是唯一的不然会删除一批。
UPDATE table
SET column = ?
WHERE (x);
?为要插入的新的值,x为列名。
SELECT *
FROM table;
FROM table
GROUP BY column;