随笔分类 -  MySql

摘要：SELECT xq.*, ts.xu_qiu_id, ts.content FROM wx_xu_qiu xq LEFT JOIN (SELECT xu_qiu_id, GROUP_CONCAT(content) AS 'content' FROM wx_track_status GROUP BY xu_qiu_... 阅读全文

摘要：SELECT s.id, s.exhi_id, s.commission, s.order_main_id, s.create_date, s.fen_xiao_id, s.state, s.update_date, DATE_ADD(s.ju... 阅读全文

摘要：INSERT INTO wx_announcement_push ( title, content, STATUS, del_flag, user_login_name ) SELECT '大家好', '我是曹XXX', 0, ... 阅读全文