列出常用的SQL语句，供以后查询
SELECT column_name,column_name FROM table_name;
SELECT * FROM table_name;
SELECT DISTINCT column_name,column_name FROM table_name;
SELECT column_name,column_name FROM table_name WHERE column_name operator value;
SELECT column_name,column_name FROM table_name ORDER BY column_name,column_name ASC|DESC;
SELECT column_name(s) FROM table_name LIMIT number;
SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern;
SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...);
SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;
SELECT column_name AS alias_name FROM table_name;
SELECT column_name(s) FROM table_name AS alias_name;
SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name;
SELECT column_name(s) FROM table1 JOIN table2 ON table1.column_name=table2.column_name;
SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name=table2.column_name;
SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name=table2.column_name;
SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name=table2.column_name;
SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2;
SELECT column_name(s) FROM table1 UNION ALL SELECT column_name(s) FROM table2;
INSERT INTO table2 (column_name(s)) SELECT column_name(s) FROM table1;
INSERT INTO table2 SELECT * FROM table1;
INSERT INTO table_name VALUES (value1,value2,value3,...);
INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...);
UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;
DELETE FROM table_name WHERE some_column=some_value;
CREATE DATABASE dbname;
CREATE TABLE table_name(column_name1 data_type(size),column_name2 data_type(size),column_name3 data_type(size),....);
CREATE INDEX index_name ON table_name (column_name);
ALTER TABLE table_name DROP INDEX index_name;
