select-mysql查询count值查不出来，显示查询超时
- WBOYOriginal
- 2016-06-06 09:43:131702browse
mysqlselect超时count
SELECT count(test.exam.id)
FROM test.exam
left join test.user
on test.exam.sfz=test.user.sfz
where test.user.area=13
查询不出来总数，最后会显示超时
每个表都有20万条左右数据
会查询600秒
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：duplicate-mysql存储过程报错,报的联合主键约束错误Next article： mysql数字排序问题。