----- Original Message ----
From: Angga Sanjaya Lingga <[EMAIL PROTECTED]>
To: [email protected]
Sent: Wednesday, April 2, 2008 1:34:03 AM
Subject: Re: [php-list] mysql error 1064
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
When I changed the columnname to loginName it gave the same error.
____________________________________________________________________________________
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]
