SQL语法

1 SELECT

SELECT "" FROM ""

2 DISTINCT

SELECT DISTINCT ""

FROM ""

3 WHERE

SELECT ""

FROM ""

WHERE ""

4 IN

SELECT ""

FROM ""

WHERE "" IN ("", "", "")

5 BETWEEN

SELECT ""

FROM ""

WHERE "" BETWEEN "" AND ""

6 LINKE

SELECT ""

FROM ""

WHERE "" LIKE ""

7 BRDER BY

SELECT ""
FROM ""

WHERE ""

ORDER BY   "" ASC

8   COUNT

SELECT COUNT("")

FROM ""

9 GROUP BY

SELECT ""

FROM ""

GROUP BY

10 HAVING

SELECT ""

FROM ""
GROUP BY ""
HAVING

11 CREATE

CREATLE TABLE ""

("" "" "" ,

 "" "" ""

) 

12 DROP

DROP TABLE ""

13

TRUNCATE

TRUNCATE TABLE ""

14 INSERT INTO

INSERT INTO ""("", "", "")

VALUES ("", "", "")

15 UPDATE ""

SET "" = ""

16 DELTE

DELETE FROM ""

WHERE