Mysql sql MEDIUMTEXT syntax error how do I? [closed]

CREATE TABLE my_table (
id INT NOT NULL AUTOINCREMENT,
thing MEDIUMTEXT NOT NULL,
PRIMARY KEY (id)
);


I get the error

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTOINCREMENT,
thing MEDIUMTEXT NOT NULL,
PRIMARY KEY (id)
)' at line 2


I am using mysql version 8

mysql Ver 8.0.23 for osx10.15 on x86_64 (Homebrew)


How can I create the table as I want?

• id column: auto-incrementing primary key
• thing: stores massive strings

Continue reading...