简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)
phpmyadmin - mysql searches the index and finds the key_name of id_2. What index is this? ?
迷茫
迷茫 2017-05-18 10:52:17
0
2
776

mysql searches the index and finds the key_name of id_2. What index is this? ?
SHOW INDEX FROM spm_works, the result is as shown below:

迷茫
迷茫

业精于勤，荒于嬉;行成于思，毁于随。

reply all(2)
淡淡烟草味
淡淡烟草味2017-05-18 10:54:17 2 floor

你应该是你创建的普通索引吧. 给看看 spm_works表的创建语句 : show create table spm_works; 看看有没有创建id_2索引 这行.
Like +0
Add Reply
巴扎黑
巴扎黑2017-05-18 10:54:17 1 floor

id_2这是建立在id字段的索引名称吧，很明显这是普通索引且不唯一。
Like +0
Add Reply
Popular Topics
More>
Popular Articles
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！