Sunday, May 2, 2010

mysql syntax error for timestamp

Programmer Question


I have this piece of SQL that is being fed to Mysql.



CREATE TABLE pn_history(
member INT,
action INT,
with INT,
timestamp DATETIME,
details VARCHAR(256)
)


But is comes back as an error about the syntax.



#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 'with INT,
timestamp DATETIME,
details VARCHAR(256)
)' at line 4


Why is this failing?





Find the answer here

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails