Article 6HA94 mysql workbench ERROR 1064

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.
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments