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 Quote 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.... Quote Link to comment https://forums.phpfreaks.com/topic/87296-solved-sql-insert-problem/#findComment-447255 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.