Dada78 Posted January 23, 2008 Share Posted January 23, 2008 I am trying to insert a new table and I keep getting an error. This is the error. #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 9 I am not sure what that means since I have it closed properly I think. Here is SQL CREATE TABLE `comments` ( `comment_ID` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT , `comment` text NOT NULL , `firstname` tinytext NOT NULL , `location` varchar( 60 ) NOT NULL , `id` varchar( 60 ) NOT NULL , `comment_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ( `comment_ID` ) , ) ; -Thanks Link to comment https://forums.phpfreaks.com/topic/87296-solved-sql-insert-problem/ Share on other sites More sharing options...
fenway Posted January 23, 2008 Share Posted January 23, 2008 In case anyone's wondering, it was the trailing comma.... Link to comment https://forums.phpfreaks.com/topic/87296-solved-sql-insert-problem/#findComment-447255 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.