Mysql
关注
分享
扫一扫
a412588063
这个作者很懒，什么都没留下…
展开
-
mysql 删除脚本
delete from test where id =1 ; OKdelete t from test t where t.id =1 ; OKdelete t from test t where t.id =1 ; Not OK原创 2016-04-15 10:39:10 · 706 阅读 · 0 评论 -
GROUP_CONCAT 函数使用，字符串大小设置
SET group_concat_max_len = 20000; SELECT m.bill_id as billId, m.bill_details_id as billDetailsId, GROUP_CONCAT(m.ime) as imes FROM (SELECT b.id as bill_id,原创 2016-04-15 10:37:56 · 1254 阅读 · 0 评论