Jump to content

[SOLVED] SQL Insert Problem


Dada78

Recommended Posts

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

Archived

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

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.