2021-05-26

**

Day3

**

SELECT M.* FROM milk_tea as m;
SELECT m.*, CONCAT(m.prod_id,prod_name,net_w) AS 产品信息 FROM milk_tea AS m;
SELECT m.*, CONCAT(prod_name,'(',net_w,')')  AS 产品信息 FROM milk_tea AS m;
SELECT m.*, CONCAT(m.prod_name,'是',m.sale_price,'单价是',m.sale_price) AS 产品信息 FROM milk_tea AS m;
/* CONCAT(str1,str2,...) 字符拼接 */

/* CONCAT_WS(separator,str1,str2,...)  字段拼接 会忽略 null空的值*/ 
SELECT m.*, CONCAT_WS('+',m.prod_name,m.sale_price,m.net_w) AS 产品信息 FROM milk_tea AS m;

SELECT 6;
SELECT CONCAT('SQl','训练营');
SELECT 15*15;
SELECT CONCAT_WS('+',1,2,3);

/*DISTINCT    内容去重，取出不同值的列,空值作为单独一列列出来*/

SELECT m.* FROM milk_tea AS m;

SELECT DISTINCT m.valid_month FROM milk_tea AS m;

SELECT DISTINCT m.sale_price FROM milk_tea AS m;

SELECT DISTINCT m.net_w FROM milk_tea AS m;


/*结果排序  ORDER BY 不可单独使用，非必须子句*/