Please remember to write your response BELOW the previous text. ----- Original Message ----- From: Tedit kap
Hi, I was trying to create a table (I already created the database) using mysql query and as this was my first time ever, I just pasted the code below from a tutorial just to see what is going to happen: CREATE TABLE Member ( loginName VARCHAR(20) NOT NULL, createDate DATE NOT NULL), PRIMARY KEY(columnname) ) I got an error message like this: MySQL said: #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 ' PRIMARY KEY(columnname) )' at line 3 Can somebody help? I was using the SQL query box in my hosting account's mysql databases section. ----------------------- Because the columnname in your table does not exsit. Regards, --- Angga Sanjaya Lingga
