分表之后全文索引要怎么处理

引用:

mysql> CREATE TABLE t1 (

    ->    a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

    ->    message CHAR(20),
->    FULLTEXT `message ` (`message `));

mysql> CREATE TABLE t2 (

    ->    a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

->    message CHAR(20),
->    FULLTEXT `message ` (`message `));

mysql> INSERT INTO t1 (message) VALUES ('Testing'),('table'),('t1');

mysql> INSERT INTO t2 (message) VALUES ('Testing'),('table'),('t2');

引用:

mysql> CREATE TABLE total (

    ->    a INT NOT NULL AUTO_INCREMENT,

    ->    message CHAR(20), INDEX(a),FULLTEXT `message ` (`message `))

    ->    TYPE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;