Sami Posted July 21, 2011 Share Posted July 21, 2011 Some time ago I've been here on this forum, but now, after some time, I'm trying to make a PHP script again...and as usual, I need some help.I'm trying to run this query: CREATE TABLE movies ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, agelimit CHAR(30) NOT NULL, release CHAR(30) NOT NULL, added DATE NOT NULL, PRIMARY KEY (id)); But violently, just out of the sky, this error message appears: #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 'release CHAR(30) NOT NULL, added DATE NOT NULL, PRIMARY KEY (id) )' at line 5 Link to comment Share on other sites More sharing options...
justsomeguy Posted July 21, 2011 Share Posted July 21, 2011 Release is a reserved word.http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.