When I try to make the table user I get this error

Error

MySQL said: You have an error in your SQL syntax near 'user(user_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,username VARCHAR(20) ' at line 1.

Query: CREATE TABLE user(user_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,username VARCHAR(20) NOT NULL DEFAULT 'DEFAULT ' ,password VARCHAR(50) NOT NULL DEFAULT 'DEFAULT ' ,email VARCHAR(50) NOT NULL DEFAULT 'DEFAULT ' ,access INT(1) UNSIGNED NOT NULL DEFAULT 'DEFAULT \'0\'' , PRIMARY KEY (user_id,username ))

I don't know what the error means, can anyone help me :(

Hi,

this error is caused by the missing table name. Please try to type in the table name first

regards,


Cheers,

Dat

Programming and creating plugins and templates
Blog