连表查询
Gxiaodiao opened this issue · 0 comments
Gxiaodiao commented
/sqladvisor -u xx -p xx -P 3306 -h xxx -d sms -q 'SELECT d.id,a.sms_id,a.customer_id,d.phone,d.send_state,d.fail_msg,a.send_time FROM sms_record_detail d LEFT JOIN sms_record a on a.sms_id=d.sms_id WHERE d.create_time between "2022-10-30 00:00:00" and "2022-10-31 14:36:15" and a.app_id="eIfpuFBf"' -v 1
2022-10-31 16:58:56 625533 [Note] 第1步: 对SQL解析优化之后得到的SQL:select had some error
2022-10-31 16:58:56 625533 [Note] 第2步：开始解析join on条件:a.sms_id=d.sms_id
2022-10-31 16:58:56 625533 [Note] 第3步：开始选择驱动表,一共有1个候选驱动表
2022-10-31 16:58:56 625533 [Note] explain select * from sms_record_detail
段错误 (核心已转储)
报错，不能分析出来