Skip to main content

HOW TO REMOVE FULLTEXT INDEX FROM COLUMN IN MYSQL TABLE

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

Popular posts from this blog

Payback Points - How to redeem - How to merge multiple payback accounts - Block Payback card - Payback customer care

How to apply for a new ration card and what are the documents required?

List of documents required for new ration card application in Kerala and how to apply


Application for a new ration card should be addressed to Taluk Supply Officer (TSO) / City Rationing Officer (CRO) of applicant's residing area.

Primary document required are Residence certificate, Income certificate and incase the applicant's name is in another ration card then he/she should submit the reduction certificate ontained from previous TSO / CRO as proof for removing his/her name from old Ration card.

You can get the new application from your currently residing Taluk Supply Office.

Your SBI Debit card ending with XX0000 is deactivated only for Internet txn.

SBI account holders may have received an SMS with following message, supposed to be from State Bank of India (SBI).

Your SBI Debit card ending with XX0000  is deactivated only for Internet txn. To activate send SMS "SWON ECOM 0000" to 09223966666. No change for ATM/POS usage
** Replace the four Zeros with last 4 digits of your debit card number

Recently many of the SBI account holder has losed their money due to a hi-tech ATM robbery which happened in Thiruvananthapuram, capital city of Kerala.


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 »
Member
Search This Blog