Jump to content

Can't run MySQL query


Sami

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...