mysql workbench ERROR 1064
by Al99 from LinuxQuestions.org on (#6HA94)
Hi I created a new schema in mysql workbench and set it to default but when I click on create table I get the following error:
Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `new_schema`.`new_table` (
);
ERROR 1064: 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 ')' at line 2
SQL Statement:
CREATE TABLE `new_schema`.`new_table` (
)
why am I getting this error?
is mysql properly installed?
how can I fix it?
thanks.
Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `new_schema`.`new_table` (
);
ERROR 1064: 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 ')' at line 2
SQL Statement:
CREATE TABLE `new_schema`.`new_table` (
)
why am I getting this error?
is mysql properly installed?
how can I fix it?
thanks.