rds for mysql 8.0是否支持全文检索-j9九游会登录

mysql 8.0版本支持全文检索，关键字为fulltext。可执行如下sql语句测试。

• 创建表

create table article (
id int unsigned not null auto_increment, 
title varchar(200) default null, 
content text,
primary key (id), 
fulltext key title (title,content),
fulltext key fulltext_article (title,content)
) engine=innodb default charset=utf8;

• 创建索引

  alter table article add fulltext index fulltext_article (title,content);

• 查看索引

  show index from article;