Topic: mysql error upon entry of normal query (Read 692 times)
aka J Love Community Supporter?
Bill Gates is my home boy
Gender:
Posts: 884
1636 credits Members referred : 4
« on: Jan 23, 2006, 04:53:44 PM »
i receive a mysql error when trying to run this simple, everyday, normal query:
Code:
CREATE TABLE `news` ( `id` int(10) NOT NULL auto_increment, `title` varchar(50) NOT NULL default '', `author` varchar(30) NOT NULL default '', `content` text NOT NULL, `postdate` varchar(25) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM
CREATE TABLE `news_comments` ( `id` int(10) NOT NULL auto_increment, `author` varchar(30) NOT NULL default '', `content` text NOT NULL, `postdate` varchar(125) NOT NULL default '', `nid` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM
this is the error that i receive
Quote
#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 'CREATE TABLE `news_comments` ( `id` int(10) NOT NULL auto_inc