otuatail Posted November 15, 2007 Share Posted November 15, 2007 Can't figure out why a simple insert is not working. Tearing hair out DROP TABLE IF EXISTS `news`; CREATE TABLE IF NOT EXISTS `news` ( `id` int(11) NOT NULL auto_increment, `Submitted` smallint(2) unsigned default NULL, `SubmitDate` int(4) unsigned default NULL, `content` text default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `news` VALUE ('', 3 , 1197996534 ,'Paul We are a team and we share everything'); #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 'VALUE ('', 3 , 1197996534 ,'Paul We are a team and we share eve Quote Link to comment Share on other sites More sharing options...
otuatail Posted November 15, 2007 Author Share Posted November 15, 2007 Sorry Speeling error VALUES not VALUE Quote Link to comment 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.