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.
____________________________________________________________________________________
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]
