Home >Backend Development >PHP Tutorial >mysql 的一个sql 话语 优化
mysql 的一个sql 话语 优化
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-13 11:44:45913browse
mysql 的一个sql 语句 优化
SELECT t_wenzhang.contents, t_wenzhang.createTime, t_wenzhang.title,t_wenzhang.pagePath FROM t_wenzhang LEFT JOIN t_keys ON t_keys.id = t_wenzhang.keyword where SUBSTRING( KeyP, 1, 1 )='" + zimu + "' order by createTime desc
上面t_wenzhang 表4W 数据，t_keys 3W，怎么这个执行10+秒！如果和优化！
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：从api中抓取数据的有关问题Next article：thankphp里面双循环如何写