学习博客：【MySQL】查询

Data Query Language

1. SELECT语法

SELECT [ALL | DISTINCT]
{
  * | table.* | [table.field1[AS alias1][,table.field2[AS alias2]][,...]]}
FROM table_name [AS table_alias]
	[LEFT | RIGHT | INNER JOIN table_name2]	--联合查询
	[WHERE ...]	--指定结果需满足的条件
	[GROUP BY ...]	--指定结果按照哪几个字段来分组
	[HAVING] --过滤分组的记录必须满足的次要条件
	[ORDER BY ...] --指定查询记录按一个或多个条件排序
	[LIMIT {
  [offset,]row_count | row_countOFFSET offset}];
	--指定查询的记录从哪条到哪条

[ ]可选

{ }必选

2. 查询指定字段

SELECT * FROM tb_newbee_mall_goods_category

为查询结果起名 AS 可以是字段、表

SELECT `goods_name` AS 商品,`selling_price` AS 价格 FROM tb_newbee_mall_order_item

函数Concat (a, b)

SELECT CONCAT(selling_price,'元') AS 新价格 FROM tb_newbee_mall_order_item AS newtable

去重 DISTINCT

SELECT DISTINCT `Sname` FROM test

版本

SELECT VERSION()

计算

SELECT 100/3 AS 计算结果

查询自增步长

SELECT @@auto_increment_increment

SELECT `Degree`+5 AS 提分后 FROM sc

3. WHERE字句

区间

SELECT