I tried to add a new table to a new database, I entered that it should have 2 rows and must be named tblLinks. When I set up the fields and press 'create' I get this error:

MySQL said: You have an error in your SQL syntax near 'id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id,desc))' at line 1.

Query: CREATE TABLE Link( ,id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id,desc))


how to solve this? I have added these fields in the following order:

id, int, not null, auto_increment, primary
desc, varchar(255), not null

---------------------------------------------
It's a wondefull program IF it would work, all these errors are getting me crazy...