常用结构:
SELECT FROM WHERE GROUP BY HAVING ORDER BY ASC/DESC 默认ASC
INSERT INTO VALUES
UPDATE SET WHERE
DELETE FROM WHERE
细节:
MYSQL中不支持TOP
前10条一般用LIMIT 0,10
#表示临时表
星号(*)是选取所有列的快捷方式。
复制表
SELECT * INTO B FROM A WHERE 1=0;// 带WHERE是只复制表结构
常见语法
DISTINCT
BETWEEN
LIKE
AND
OR
AS
NOT
IN
GROUP BY HAVING
EXISTS
常用函数,参数通常是column_name或*或distinct *或函数嵌套
MIN()
MAX()
COUNT()
AVG()
SUM()
ALL
ANY
FIRST()
LAST()
UCASE()
LCASE()
MID()函数用于从文本字段中提取字符。
SELECT MID(column_name,start,[length]) FROM table_name
LEN() 函数返回文本字段中值的长度。
ROUND()
SELECT ROUND(column_name,decimals) FROM table_name
NOW()
FORMAT()函数用于对字段的显示进行格式化。
SELECT ProductName, UnitPrice, FORMAT(Now(),'YYYY-MM-DD') as PerDate FROM Products