#1113 - A table must have at least 1 column

sql2000 · #1 (**permalink**) 09-20-11, 01:44

Hi Everyone,

Im having a problem while creating a table in mysql. When i create a table i got following error
"#1113 - A table must have at least 1 column"
I need to know why this error comes everytime when i create a table.
Pls help.

REgards
Aaja

healdem · #2 (**permalink**) 09-20-11, 03:14

probably you get this error message when you fail to add at least one column to a new table

how are you creating these tables
do you have sufficient privileges to create tables and or adjust the design

it-iss.com · #3 (**permalink**) 09-20-11, 04:23

If you show us the SQL you are using to create the table this might help us point you in the right direction?

Internet Services

Web Development

Digital Marketing

Consumer Tech