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 (
login VARCHAR(20) NOT NULL,
createdate DATE NOT NULL),
PRIMARY KEY(login) )

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(login) )' at line 3 

Can somebody help? I was using the SQL query box in my hosting account's mysql 
databases section.  


      
____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total 
Access, No Cost.  
http://tc.deals.yahoo.com/tc/blockbuster/text5.com

[Non-text portions of this message have been removed]

Reply via email to