sql 指令的语法（Syntax for SQL instructions）.docVIP

sql 指令的语法（Syntax for SQL instructions） On this page, we list all the syntax for listing SQL instructions on this site. For more detailed instructions, click the instruction name. The purpose of this page is to provide a concise SQL syntax for reader reference purposes. We recommend that you press Control-D to add this page to your my favorite. Select SELECT field FROM table name Distinct SELECT DISTINCT field FROM table name Where SELECT field FROM table name WHERE condition And/Or SELECT field FROM table name WHERE simple condition {[AND|OR] simple}+ In SELECT field FROM table name WHERE field, IN (value 1, value 2,...) Between SELECT field FROM table name WHERE field, BETWEEN , value 1AND, value 2 Like SELECT field FROM table name WHERE field, LIKE, {mode} Order By SELECT field FROM table name [WHERE condition] ORDER BY field, [ASC, DESC] Count SELECT COUNT (field) FROM table name Group By SELECT field 1, SUM (field 2) FROM table name GROUP BY field 1 Having SELECT field 1, SUM (field 2) FROM table name GROUP BY field 1 HAVING (column) Create Table CREATE TABLE table name (column 1, column 1, data type, Column 2, column 2, data type, ...) Drop Table DROP TABLE table name Truncate Table TRUNCATE TABLE table name Insert Into INSERT INTO table name (field 1, column 2,...) VALUES (1, 2,...) Update UPDATE table name SET field 1 = [new value] WHERE {condition} Delete From DELETE FROM table name WHERE {condition} Sentence function -- data manipulation SELECT -- retrieve data rows and columns from a database table INSERT -- adding new data rows to a database table DELETE -- deletes rows of data from the database table UPDATE -- update the data in the database table -- data definition CREATE TABLE - create a database table DROP TABLE -- delete tables from the database ALTER TABLE - modify the database table structure CREATE VIEW - create a view DROP VIEW -- delete views from the database CREATE INDEX -- creates an index for the database table DROP INDEX -- removes indexes