MySQL 5.5 Community Server MySQL 5.6 Community Server Percona Configuration Wizard XtraBackup 搭建主从复制 Great Sites on MySQL Percona MySQL Performance Blog Severalnines 推荐管理工具 Sequel Pro phpMyAdmin 推荐书目 MySQL Cookbook
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html 
这是一个创建于 1776 天前的主题，其中的信息可能已经有所发展或是发生改变。
SELECT t1.name, t2.course_id, t2.count_class_session, t2.sum_duration, t4.id, t4.rowNo FROM `tb_course` t1 LEFT JOIN ( SELECT course_id, count(*) count_class_session, sum( duration ) sum_duration FROM tb_class_session GROUP BY course_id ) t2 ON t2.course_id = t1.id LEFT JOIN tb_learn_record t3 ON t3.course_id = t1.id LEFT JOIN ( SELECT a.id, ( @rowNum := @rowNum + 1 ) AS rowNo FROM tb_class_session a, ( SELECT ( @rowNum := 0 ) ) b ORDER BY a.sequence_no ASC ) t4 ON t4.id = t3.class_session_id 求助 如何 把 t1.id 传入 SELECT a.id, ( @rowNum := @rowNum + 1 ) AS rowNo FROM tb_class_session a, ( SELECT ( @rowNum := 0 ) ) b ORDER BY a.sequence_no ASC 内
Select Language