sql 语句

一、语法

SELECT column1, column2
FROM table
WHERE [ conditions ]
GROUP BY column1, column2
HAVING [ conditions ]
ORDER BY column1, column2

 二、练习

增、删、改、查

 1.增

INSERT INTO tableName (phone,name,status) VALUES(1,2,3)
INSERT INTO tableName (phone,name) VALUES(100001,2000001)

2.删除

DELETE FROM tableName WHERE phone = "1"

3.更新

UPDATE tableName   SET name ="150" WHERE id == 10

4.查询

SELECT * FROM tableName  ORDER BY   status DESC;

SELECT * FROM tableName  GROUP BY  name ORDER BY   id DESC;

SELECT avg(name) AS 'ch' FROM tableName GROUP BY status  HAVING 'ch'>100;

三、用到的关键字

INSERT

UPDATE 

SELECT

ORDER BY

from

GROUP BY

HAVING