php fulltext index innodb - phpmyadmin / MySQL

Anybody that knows of where to find or can knit step-by-step descriptions of how to CREATE and to DELETE a php fulltext index on MySQL-InnoDB using phpMyAdmin?

Replay

I'm afraid you'll have to write these sql commands manually in phpMyAdmin or MySQL console. Something like CREATE FULLTEXT INDEX idx ON table_name(column_name);

See the official documentation for the detailed instructions: https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html

If you are using a PHP framework that has ORM and supports migrations, you can place your sql statements inside the migrations. For instance, in Laravel it would look like DB::statement('ALTER TABLE posts ADD FULLTEXT full(name, content)');

This is actually really simple. To add it, go to the "Structure" tab and just click the "Fulltext" link in the "Action" area.

php fulltext index innodb - phpmyadmin / MySQL

To remove it, you might have to expand the "Indexes" area, then click "Drop" for the index that corresponds to the Fulltext index you wish to remove.

As mentioned by @sammitch, it appears that MySQL support for this index began with 5.6.

Category: php Time: 2016-01-26 Views: 4

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.116 (s). 12 q(s)