Tag Archives: sql FULLTEXT

How to Solve SQL fulltext error

Today, the synchronization database reported an error FULLTEXT.
Reason: The 5.6 version synchronizes to 5.5 and an error is reported because it contains the FULLTEXT index.

Solution: Delete the index according to the prompt.

Information: Before MySQL version 5.6, only the MyISAM storage engine supports the full-text engine. In version 5.6, InnoDB added support for full-text indexing, but it does not support Chinese full-text indexing. In version 5.7.6, MySQL has a built-in full-text parser for ngram , Used to support participles of AsianĀ languages.