MySQL-trouble...

[cmxflash]

When I try to create a new table on my MySQL-server, i just get this error:

Error executing SQL commands to create table.
MySQL Error Nr. 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 ')
TYPE = MYISAM' at line 2

I use MySQL-admin to manage my databases, and this is the command i was using:

CREATE TABLE `phpbb`.`phpbb` (
)
TYPE = MYISAM;

Does anybody know how to fix this "syntax error"?

[aprelium]

cmxflash,

The CREATE TABLE syntax is in http://dev.mysql.com/doc/mysql/en/create-table.html .
It seems that having nothing between ( and ) is the cause of the error.
_________________
Support Team
Aprelium - http://www.aprelium.com

[cmxflash]

[AbyssUnderground]

[cmxflash]