Home  »     »     »  HOW TO REMOVE FULLTEXT INDEX FROM COLUMN IN MYSQL TABLE

HOW TO REMOVE FULLTEXT INDEX FROM COLUMN IN MYSQL TABLE

Tuesday, March 19, 2013

HOW TO REMOVE FULLTEXT INDEX FROM COLUMN IN MYSQL TABLE




for this first you check the DDL of your table

Here given the example which is based on a sample table "tbl_Company"

Run following Query to display the DDL for your table, including the system-assigned name for the index.


SHOW CREATE TABLE tbl_Company;

the resuly will look like this:

CREATE TABLE tbl_Company ( `Company_Id` int(11) NOT NULL auto_increment, `Company_Title` varchar(150) , `Company_Details` Text, PRIMARY KEY (`Company_Id`), FULLTEXT KEY `Company_Title` (`Company_Title`,`Company_Details`) ) ENGINE=MyISAM

Here in the above result , you can see that the full-text index is referred by the key name as `Company_Title`

To remove the Full-Text index You should refer the FULLTEXT KEY (from the above example it is "Company_Title" ) and the SQL statement comes like this:

ALTER TABLE `tbl_Company` DROP INDEX `Company_Title`;

OR

DROP INDEX `Company_Title` ON `tbl_Company`


MYSQL FULL-TEXT SEARCH QUICK REFERENCE GUIDE




How to link to this page?
If you wish to link to this page from your website, simply Copy and paste the above HTML code to your web page. It will appear on your page as:
HOW TO REMOVE FULLTEXT INDEX FROM COLUMN IN MYSQL TABLE.




Share this!




comments powered by Disqus

This Weeks 7 Popular Posts


Subscribe to Recent Posts by Email
Stay connected to CROZOOM with regular Email notices of new Techie articles and IT Jobs. Updates will be delivered to your Inbox as soon as they are posted online.

Enter Your Email Address:  

Delivered by FeedBurner   RSS Feed

Search this Blog   



Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »