mysql error #1064
2 posters
Page 1 of 1
mysql error #1064
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.
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
Re: mysql error #1064
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) )
CREATE TABLE Member (
login VARCHAR(20) NOT NULL,
createdate DATE NOT NULL,
PRIMARY KEY(login) )
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|