mysql函数使用

1.分组时，拼接一组字符串，相当于给字符串sum()  (group_concat()函数)

1.1. 实例演示：

https://blog.csdn.net/qqahanson/article/details/26820851

CREATE TABLE `jxc_orderdetail` (
  `detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(20) DEFAULT '' COMMENT '订单编号',
  `pro_no` varchar(20) DEFAULT '' COMMENT '产品编号',
  `pro_name` varchar(100) DEFAULT '' COMMENT '产品名字',
  `pro_number` int(11) DEFAULT '0' COMMENT '产品数量',
  `pro_price` decimal(10,2) DEFAULT '0.00' COMMENT '产品单价',
  `pay_price` decimal(10,2) DEFAULT '0.00' COMMENT '最后支付',
  PRIMARY KEY (`detail_id`)
) ENGINE=MyISAM AUTO_INCREMENT=139707 DEFAULT CHARSET=utf8;
 
/*Data for the table `jxc_orderdetail` */
 
insert  into `jxc_orderdetail`(`detail_id`,`order_no`,`pro_no`,`pro_name`,`pro_number`,`pro_price`,`pay_price`) 
values (139704,'H140523000001','130001','美国莎娜琳',2,'78.00','1000.00'),
(139705,'H140524000001','49101815101237','移花宫速效细肤祛痘乳100ML',1,'133.00','1000.00'),
(139706,'H140524000001','ECS000160','移花宫速效控油嫩肤水12ML',1,'39.00','1000.00');


SELECT order_no,GROUP_CONCAT(pro_name,'*',pro_number SEPARATOR '=======') FROM jxc_orderdetail GROUP BY order_no;

1.2 语法分析：

http://www.poluoluo.com/jzxy/200812/53698.html

1.3 同样的方式拼接数字，不让数字想加，而是专成char，再group_concat

http://blog.sina.com.cn/s/blog_6a17255b0101k0v7.html

1.3.1 实例演示：

将数字通过cast专成字符串，再group_concat()

SELECT order_no,GROUP_CONCAT(CAST(detail_id as char)) FROM jxc_orderdetail GROUP BY order_no;