Mysql基本语句

1、增

INSERT INTO people VALUES (6,'jef',9,NULL);

2、删

DELETE FROM people WHERE id = 6;

3、改

UPDATE people SET NAME = 'timo' WHERE id = 1;

4、查

SELECT *FROM people WHERE `name` = 'tom';
SELECT *FROM people WHERE age > 10 AND  height >150;
SELECT *FROM people WHERE age BETWEEN 10 AND 60;