sql 语句笔记

SELECT * FROM t_table;
SELECT name FROM t_table;
SELECT name FROM t_table WHERE id = 1;
SELECT name, age FROM t_table WHERE name LIKE '%王%';

DELETE FROM t_table;
DELETE FROM t_table WHERE id = 1;

INSERT INTO
t_table ('name', 'age')
VALUES ('麻子', '26');

UPDATE t_table
SET
  name = '章三',
  age = '34'
WHERE
  id = 1;

truncate table t_table

SELECT * FROM t_table ORDER BY age;

SELECT * FROM t_table ORDER BY age DESC;

SELECT * FROM t_table ORDER BY age, name;

SELECT * FROM t_table ORDER BY age DESC, name ASC;