Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

连表查询 #4

Open
Gxiaodiao opened this issue Oct 31, 2022 · 0 comments
Open

连表查询 #4

Gxiaodiao opened this issue Oct 31, 2022 · 0 comments

Comments

@Gxiaodiao
Copy link

/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

段错误 (核心已转储)
报错,不能分析出来

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant