natasha_sharma Posted March 17, 2016 Share Posted March 17, 2016 (edited) 1) I am using XAMPP. MySQL Server version: 10.1.9-MariaDB Table corp_news has around 10,000 rows. I am using below query to create Index using PHPMyADmin. ALTER TABLE corp_news ADD FULLTEXT INDEX `corp_nz` (`content` ASC, `subject` ASC); After running this query, On left hand side menu, when i click the "index" from the tree i see many indexes named like content2 content3 content4 . . . . content37 subject2 subject3 subject4 . . . . subject36 subject37 I thought it would create only one Index table named "corp_nz". what the heck so many index tables about? Is this normal? 2) If this is the case, how can i even drop the full text index on "corp_news" table? Edited March 17, 2016 by natasha_sharma Quote Link to comment https://forums.phpfreaks.com/topic/301027-mysql-full-text-search-so-many-indexes/ Share on other sites More sharing options...
QuickOldCar Posted March 17, 2016 Share Posted March 17, 2016 Possibly the other indexes created via the script you posted in past. To drop indexes...In phpmyadmin click the structure tab and scroll below, click the x on any no longer want. Quote Link to comment https://forums.phpfreaks.com/topic/301027-mysql-full-text-search-so-many-indexes/#findComment-1532106 Share on other sites More sharing options...
natasha_sharma Posted March 17, 2016 Author Share Posted March 17, 2016 Dear QOC, I just ran this query in PhpMyAdmin: CREATE FULLTEXT INDEX corp_nz ON corp_news(content ASC, subject ASC) Earlier script has nothing to do with this table. Quote Link to comment https://forums.phpfreaks.com/topic/301027-mysql-full-text-search-so-many-indexes/#findComment-1532112 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.