Ruud Hermans Posted July 1, 2009 Share Posted July 1, 2009 WHen running the following query: CREATE TABLE members( id INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , name VARCHAR( 30 ) NOT NULL , PASSWORD VARCHAR( 30 ) NOT NULL , email VARCHAR( 30 ) , location VARCHAR( 30 ) NOT NULL , registered DATE( ) ); I get this error from PHPMyAdmin: #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 '( ) )' at line 7 Anyone know what could be wrong? Link to comment https://forums.phpfreaks.com/topic/164420-solved-what-is-wrong-in-this-query/ Share on other sites More sharing options...
corbin Posted July 1, 2009 Share Posted July 1, 2009 Did you read the error at all? Anyway: registered DATE( ) Should be registered DATE Link to comment https://forums.phpfreaks.com/topic/164420-solved-what-is-wrong-in-this-query/#findComment-867297 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.