Error
Static analysis:
1 errors were found during analysis.
A comma or a closing bracket was expected. (near "WITH" at position 158)
SQL query: Copy
CREATE TABLE articles ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), body TEXT, FULLTEXT (title,body) WITH PARSER ngram ) ENGINE=InnoDB CHARACTER SET utf8mb4;
MariaDB said: Documentation
#1128 - Function 'ngram' is not defined
示例命令如下:
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT (title,body) WITH PARSER ngram
) ENGINE=InnoDB CHARACTER SET utf8mb4;
ALTER TABLE articles ADD FULLTEXT INDEX ft_index (title,body) WITH PARSER ngram;
给出此错误:
Error
Static analysis:
1 errors were found during analysis.
A new statement was found, but no delimiter between it and the previous one. (near "WITH" at position 62)
SQL query: Copy