1.SQL AND/OR 子句:
SELECT column1, column2....columnNFROM table_nameWHERE
CONDITION-1 {AND|OR} CONDITION-2;
2.In 子句
SELECT column1, column2....columnN FROM table_name WHERE
column_name IN (val-1, val-2,...val-N);
3.BETWEEN 子句
SELECT column1, column2....columnN FROM table_name
WHERE column_name
BETWEEN val-1 AND val-2;
4.like 子句
SELECT column1, column2....columnN FROM table_name
WHERE column_name
LIKE { PATTERN };
5.SQL ORDER BY 子句:
SELECT column1, column2....columnN FROM table_name
WHERE CONDITION
ORDER BY column_name {ASC|DESC};
6.SQL GROUP BY 子句:
SELECT SUM(column_name) FROM table_name
WHERE CONDITION
GROUP BY column_name;
7.SQL COUNT 子句:
SELECT COUNT(column_name) FROM table_name
WHERE CONDITION;
8.SQL HAVING 子句:
SELECT SUM(column_name) FROM table_name
WHERE CONDITION
GROUP BY column_name
HAVING (arithematic function condition);
9.SQL CREATE TABLE 语句:
CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
.....
columnN datatype,
PRIMARY KEY( one or more columns )
);
10.SQL DROP TABLE 语句:
DROP TABLE table_name;
11.SQL CREATE INDEX 语句 :
CREATE UNIQUE INDEX index_name ON table_name (
column1,
column2,
...
columnN
);
12.SQL DROP INDEX 语句
ALTER TABLE table_name
DROP INDEX index_name;
13.SQL DESC 语句 :
DESC table_name;
13.SQL TRUNCATE TABLE 语句:
TRUNCATE TABLE table_name;
14.SQL ALTER TABLE 语句:
ALTER TABLE table_name
{ADD|DROP|MODIFY} column_name {data_ype};
15.SQL ALTER TABLE 语句 (重命名)
ALTER TABLE table_name
RENAME TO new_table_name;
16.SQL INSERT INTO 语句:
INSERT INTO table_name( column1, column2....columnN)
VALUES ( value1, value2....valueN);
17.SQL UPDATE 语句:
UPDATE table_nameSET column1 = value1, column2 = value2....columnN=valueN
[ WHERE CONDITION ];
18.SQL DELETE 语句:
DELETE FROM table_nameWHERE {CONDITION};
19.SQL CREATE DATABASE 语句:
CREATE DATABASE database_name;
20.SQL DROP DATABASE 语句:
DROP DATABASE database_name;
21.SQL USE 语句:
USE database_name;
