1

In order to be able to create tables with capital letters I had to modify the my.ini file in ProgramData\MySQL\MySQL Server 5.7, U added lower_case_table_names = 2 at the end of the file like it was suggested here, when I closed MySQL server and restarted it couldn't create any new tables, so I removed the line I added, restarted the server again, I keep having this error 

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `toys`.`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 `toys`.`new_table` (
)
Community
  • 1
  • 1
user6008337
  • 221
  • 3
  • 15

1 Answers1

1

You cannot create a table without columns - you need something between the brackets there. E.g.:

CREATE TABLE `toys`.`new_table` (
    id INT -- just for example
);
Mureinik
  • 297,002
  • 52
  • 306
  • 350