用一次，查一次的SQL
2017-12-14 本文已影响0人
Super7
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 列名称 = 值
