Mysql – How to make a empty MySQL table


What is wrong with the following syntax? This is the code that MySQL work bench made and I can't tell what is wrong with it.

CREATE TABLE `data1`.`table1` ();

Best Solution

You are trying to create a table without columns. That is not possible in MySQL. You need to specify at least one column in order to create table.