SQL高级教程（一）

SQL 基础教程

TOP

• 用于规定要返回的记录的数目

#MYSQL语法
SELECT column_name(s)
FROM table_name
LIMIT number|percent

LIKE

• 用于在 WHERE 子句中搜索列中的指定模式
• 通配符用来替代一个或多个字符
  

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern

#选取以N开头的城市
SELECT * FROM Persons
WHERE City LIKE 'N%'

#选取以g结尾的城市
SELECT * FROM Persons
WHERE City LIKE '%g'

#选取包含lon的城市
SELECT * FROM Persons
WHERE City LIKE '%lon%'

#选取不包含lon的城市
SELECT * FROM Persons
WHERE City NOT LIKE '%lon%'

#选取名字第一个字符之后是eorge
SELECT * FROM Persons
WHERE FirstName LIKE '_eorge'

#选取以A或L或N开头的城市
SELECT * FROM Persons
WHERE City LIKE '[ALN]%'

#选取不以A或L或N开头的城市
SELECT * FROM Persons
WHERE City LIKE '[!ALN]%'

IN

• 允许在 WHERE 子句中规定多个值

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)

BETWEEN

• 在 WHERE 子句中规定两个值之间的数据

SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2

#字母顺序
SELECT * FROM Persons
WHERE LastName
BETWEEN 'Adams' AND 'Carter'

SELECT * FROM Persons
WHERE LastName
NOT BETWEEN 'Adams' AND 'Carter'

SQL高级教程（二）