sk1tL1L Posted July 8, 2006 Share Posted July 8, 2006 hey all i'm inserting this script to phpmyadmin:CREATE TABLE forum_posts (post_id int NOT NULL PRIMARY KEY AUTO_INCREMENTtopic_id int NOT NULL,post_text text,post_create_time datetime,post_owner varchar( 150 ));and it is coming up with this 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 'topic_id int NOT NULL,post_text text,post_create_time datetime,post_owner ' at line 3 thanks Quote Link to comment https://forums.phpfreaks.com/topic/14061-mysql-error-1064/ Share on other sites More sharing options...
dual_alliance Posted July 8, 2006 Share Posted July 8, 2006 I think you have only forgotten one small ',' so this should work.[code]CREATE TABLE forum_posts (post_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,topic_id int NOT NULL,post_text text,post_create_time datetime,post_owner varchar( 150 ));[/code] Quote Link to comment https://forums.phpfreaks.com/topic/14061-mysql-error-1064/#findComment-54984 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.