Why I cant create a table in mysql?-CodePudding

Im starting with mysql, but it doesnt allow me to create a simple table. It says: "A table must have at least one visible column".

CodePudding user response：

Columns must be added to the table during its creation

try

CREATE TABLE LOCURA (`id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

CodePudding user response：

There need to be at least one column when creating

CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);