Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged mysql同表，flag只有两个值，要求查出值

0 votes
2.4k views
1 answer
mysql同表，flag只有两个值，要求查出值 flag1存在，flag2不存在的数据？
    表数据较大，大约一百万条 目前思路是左连接，但会走全表查询，速度很慢 select si1.* from service_info si1 left outer join service_info si2 on si1.service_id = si2.service_id ... 的解决方法或思路？目前仅使用 sql 查询，不做其他例如分区表或分表操作 ...
asked Jan 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
To see more, click for the full list of questions or popular tags.
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

Just Browsing Browsing

2.1m questions

2.1m answers

60 comments

57.0k users

Most popular tags

Powered by Question2Answer
Donate
Theme by Q2A Market&&OStack.cn
...