sql MyISAM的全文搜索FULLText_weixin_34378767的博客

创建

create table products (
    id int NOT NULL AUTO_INCREMENT,
    prod_id char(10) NOT NULL,
    content text NULL,
    PRIMARY KEY(id),
    FULLTEXT(content)
) ENGINE = MyISAM;create table products (
    id int NO