update
UPDATE table SET row_name = 新值 WHERE row_name= 某值
order by
参数 | 说明 |
---|---|
DESC | 逆序 |
ASC | 升序 |
ex.
SELECT a, b FROM table ORDER BY a DESC, b ASC
INSERT
ex.
INSERT INTO table VALUES (data1, data2,....)
or
INSERT INTO table (row1, row2,...) VALUES (data1, data2,....)
DELETE
ex.
DELETE FROM table WHERE 列名称 = 值
网友评论