Why can't my full-text index be created directly when creating a table ? Prompt syntax error when running mysql The version is 8.0 But my has no problem creating full-text indexes on existing tables
The code is as follows :CREATE TABLE t_class10(
classno INT(4),
cname VARCHAR(20),
loc VARCHAR(40),
FULLINDEX INDEX index_loc(loc)
);
Error message : Error Code: 1064. You have an error in your SQL syntax; check the manual that 0.000 seccorresponds to your MySQL server version for the right syntax to use near 'INDEX index_loc(loc) )' at line 5