MySQL常用语句

#创建数据库
CREATE DATABASE database_name;
#删除数据库
drop database database_name;
#选择数据库
use database_name;
#创建数据表
CREATE TABLE table_name (column_name column_type,column_name column_type);
#删除数据表
DROP TABLE table_name ;
#插入数据
INSERT INTO table_name ( field1, field2,...fieldN )
                       VALUES
                       ( value1, value2,...valueN );
#查询数据
SELECT column_name,column_name
FROM table_name
[WHERE Clause]
[LIMIT N][ OFFSET M]

#WHERE 子句
SELECT field1, field2,...fieldN FROM table_name1, table_name2...
[WHERE condition1 [AND [OR]] condition2.....
 
#UPDATE 更新
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]
 
#DELETE 语句 删除某条(些)数据
DELETE FROM table_name [WHERE Clause]
 
#LIKE 子句 模糊查询：% 字符来表示任意字符，类似于正则表达式中的 *。
SELECT field1, field2,...fieldN 
FROM table_name
WHERE field1 LIKE condition1 [AND [OR]] filed2 = ‘somevalue‘
 
#UNION 操作符
SELECT expression1, expression2, ... expression_n
FROM tables
[WHERE conditions]
UNION [ALL | DISTINCT]	#DISTINCT:删除结果集中重复的数据; ALL:返回所有结果集，包含重复数据。
SELECT expression1, expression2, ... expression_n
FROM tables
[WHERE conditions];

MySQL常用语句