Help fix my error in your SQL syntax?

[bobby2guns2003]

SQL query:

--
-- Dumping data for table `wp_posts`
--
INSERT INTO `wp_posts` ( `ID` , `post_title` , `post_servings` , `post_content` , `post_author` , `post_date` , `post_date_gmt` , `post_category` , `post_excerpt` , `post_status` , `comment_status` , `ping_status` , `post_password` , `post_name` , `to_ping` , `pinged` , `post_modified` , `post_modified_gmt` , `post_content_filtered` , `post_parent` , `guid` , `menu_order` , `post_type` , `post_mime_type` , `comment_count` ) ;

MySQL said: Documentation
#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 1

what am I doing wrong?

 

[Decker]

http://www.google.co.uk/search?hl=en&q=mysql+#1064+xoops&meta=

Loads of results, you don't say what with or what you were doing, nor can we see the sql file or what it's from or for?????

 

[brutetal]

Where's "VALUES"?

YOU MUST STATE "VALUES" AFTER THE TABLE NAME
OR!!!
AFTER YOU STATE THE TABLE COLUMS!

Then you would state the values that would go into each colum.

Please check your syntax before asking for help.

 

[TSO]

The field names need no single quotes. And as brutetal says, you have provided no values, so there's nothing to insert- hence, the reason it is not working.