CREATE DATABASE IF NOT EXISTS DB_NAME DEFAULT utf8 CLLATE utf8_general_ci
# 如果不存在则创建；默认字符集utf8，不是utf-8；大小写不敏感

USE DB_NAME 

# 语法
CREATE TABLE table_name (colume_name column_type);
# 例
CREATE TABLE IF NOT EXISTS `runoob_tbl`(
   `runoob_id` INT UNSIGNED AUTO_INCREMENT,
   `runoob_title` VARCHAR(100) NOT NULL,
   `runoob_author` VARCHAR(40) NOT NULL,
   `submission_date` DATE,
   PRIMARY KEY ( `runoob_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

# 语法
INSERT INTO table_name (filed1, filed2, ...)
				VALUES
						(value1, value2, ...)

# 基本语法
SELECT colume_name1,colume_name2
FROM table_name1,table_name2
[WHERE Clause]
[ORDER BY ]
[LIMIT N]
[OFFSET M]

# 检索 6-15 行 （第5行后的10行）
SELECT * FROM table_name LIMIT 5,10 
# 检索 6-15 行 （第5行后的10行，更常用第一种格式）
SELECT * FROM table_name LIIMIT 10,OFFSET 5

# 前5行
SELECT * FROM table_name LIMIT 5
# 等同于
SELECT * FROM table_name LIMIT 0,5

# 第6行到最后一行 （第5行后的所有行）
SELCT * FROM table_name LIMIT 5,-1

# 常用于分页
设 count 为每页显示的条数，number为页码，
那么，第number页的count条数据为：
SELECT * FROM table_name LIMIT (number-1)*count,count

# 基本语法，默认升序（可不写DESC）
SELECT * FROM table_name ORDER BY column_name DESC

# 多列排序
SELECT column1,column2 FROM table_name ORDER BY column1 ASC,column2 DESC 

# 基本语法
SELECT field1,field2,... FROM table1,table2,...
WHERE condition1 AND/OR condition2

# 字符串的比较不区分大小写
SELECT * FROM table_name WHERE column_name = "myName"

# 区分大小写
SELECT * FROM table_name WHERE BINARY column_name = "myName"

# 可用的操作符
#  = ; != ; > ; < ; >= ; <=  

# LIKE，常与 % 一同使用，相当于元字符的搜索
# 检索 列 column_name 以 Name 结尾的行
SELECT * FROM table_name WHERE column_name LIKE "%Name"

# UNION连接多个SELECT语句
# 基本语法，默认DISTINCT已去重
SELECT column_name FROM table1
[WHRER conditions1]
UNION [ALL/DISTINCT]
SELECT column_name FROM Table2
[WHERE conditions2]
[ORDER BY column_other][ASC]

# GROUP BY 

UPDATE table_name SET field1=value1,field2=value2
[WHERE Clause]

DROP TABLE table_name

TRUNCATE TABLE table_name