mysql group_concat
来源:互联网 发布:电脑温度显示软件 编辑:程序博客网 时间:2024/06/04 19:24
$insertSql = " select max(case when goodtest.boxID = @idbox then @title := CONCAT_WS(',',@title,goodtest.isotope)";
$insertSql .= " else @title := goodtest.isotope end ) as isotope, ";
$insertSql .= " @idbox:=goodtest.boxID as boxID ";
$insertSql .= " from goodtest group by goodtest.boxID ";
$query ="SELECT @title = NULL, @idbox = 0; ";
$query .= "INSERT INTO test(isotope, boxID) ";
very very bad mysql!
$insertSql .= " else @title := goodtest.isotope end ) as isotope, ";
$insertSql .= " @idbox:=goodtest.boxID as boxID ";
$insertSql .= " from goodtest group by goodtest.boxID ";
$query ="SELECT @title = NULL, @idbox = 0; ";
$query .= "INSERT INTO test(isotope, boxID) ";
very very bad mysql!
- mysql group_concat
- mysql group_concat
- mysql group_concat
- mysql group_concat
- MySQL group_concat
- MySQL group_concat
- mysql-group_concat
- mysql group_concat
- mysql group_concat
- MYSQL group_concat
- mysql group_concat
- MySQL GROUP_CONCAT
- mysql group_concat 使用实例
- MySQL中group_concat函数
- MySQL中group_concat函数
- mysql的group_concat函数
- Mysql 函数 Group_concat()详解
- 关于mysql函数GROUP_CONCAT
- ZOJ Problem 1689 Calling Extraterrestrial Intelligence Again
- 定时执行!
- Win 2003安装后的十个小技巧
- Java性能优化技巧总结
- javascript读写Cookie
- mysql group_concat
- 你是否也喜欢旅游??
- junit实现过程
- 10个你未必知道的CSS技巧
- 推荐一本好书
- 引用:台湾经济奇迹
- iframe 的用法与注意事项
- 刘古权:大企业讲逻辑,小企业讲感情
- 如何掌握一项新技术 作者:陆其明