Art of design
Would you like to react to this message? Create an account in a few clicks or log in to continue.

mysql error #1064

2 posters

Go down

mysql error #1064 Empty mysql error #1064

Post  hamur Wed 16 Apr - 7:03

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.

hamur

Number of posts : 1
Registration date : 2008-04-15

Back to top Go down

mysql error #1064 Empty Re: mysql error #1064

Post  Feytan Wed 16 Apr - 7:06

you post in the wrong place anyway heres the solution

CREATE TABLE Member (
login VARCHAR(20) NOT NULL,
createdate DATE NOT NULL,
PRIMARY KEY(login) )
Feytan
Feytan
Admin

Number of posts : 14
Age : 35
Registration date : 2007-11-21

http://www.myportfolio.hyperphp.com/

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum