所有SQL语句均以SELECT,INSERT,UPDATE,DELETE,ALTER,DROP,CREATE,USE,SHOW等任何关键字开头,所有均以分号(;)结尾。
这里要注意的最重要一点是SQL不区分大小写,这意味着SELECT和select在SQL语句中具有相同的含义。
链接:https://www.learnfk.comhttps://www.learnfk.com/sql/sql-syntax.html
来源:LearnFk无涯教程网
SELECT column1, column2....columnN FROM table_name;
SELECT DISTINCT column1, column2....columnN FROM table_name;
SELECT column1, column2....columnN FROM table_name WHERE CONDITION;
SELECT column1, column2....columnN FROM table_name WHERE CONDITION-1 {AND|OR} CONDITION-2;
SELECT column1, column2....columnN FROM table_name WHERE column_name IN (val-1, val-2,...val-N);
SELECT column1, column2....columnN FROM table_name WHERE column_name BETWEEN val-1 AND val-2;
SELECT column1, column2....columnN FROM table_name WHERE column_name LIKE { PATTERN };
SELECT column1, column2....columnN FROM table_name WHERE CONDITION ORDER BY column_name {ASC|DESC};
SELECT SUM(column_name) FROM table_name WHERE CONDITION GROUP BY column_name;
SELECT COUNT(column_name) FROM table_name WHERE CONDITION;
SELECT SUM(column_name) FROM table_name WHERE CONDITION GROUP BY column_name HAVING (arithematic function condition);
CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );
DROP TABLE table_name;
CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);
ALTER TABLE table_name DROP INDEX index_name;
DESC table_name;
TRUNCATE TABLE table_name;
ALTER TABLE table_name {ADD|DROP|MODIFY} column_name {data_ype};
ALTER TABLE table_name RENAME TO new_table_name;
INSERT INTO table_name( column1, column2....columnN) VALUES ( value1, value2....valueN);
UPDATE table_name SET column1=value1, column2=value2....columnN=valueN [ WHERE CONDITION ];
DELETE FROM table_name WHERE {CONDITION};
CREATE DATABASE database_name;
DROP DATABASE database_name;
USE database_name;
COMMIT;
ROLLBACK;
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)