Looks like you are using backticks instead of single quotes on your column names. You don't really need the quotes on your table name or column names anyway, so I'd just remove them.
On Tue, 2004-04-06 at 09:29, Marvin Cummings wrote: > > > > _____ > > From: Marvin Cummings [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 9:26 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Need help creating table... > > > > I attempt to create this table from the command line and get the following > error: > > Error 1064 (42000): You have an error in your SQL syntax. Check the manual > that corresponds to your MySQL version for the right syntax to use near > ''ad_id' smallint(5) unsigned NOT NULL auto_increment, 'cat_id' smallint(5) > unsign' at line 3 > > CREATE TABLE 'nuke_zc_ads' > > ( > `ad_id` smallint(5) unsigned NOT NULL auto_increment, > `cat_id` smallint(5) unsigned NOT NULL default '0', > `user_name` varchar(20) NOT NULL default '', > `email` varchar(50) NOT NULL default '', > `price` text NOT NULL, > `condition` varchar(10) NOT NULL default '', > `city` varchar(20) NOT NULL default '', > `state` varchar(20) NOT NULL default '', > `country` varchar(20) NOT NULL default '', > `lastup_date` int(11) NOT NULL default '0', > `subject` text NOT NULL, > `descript` text NOT NULL, > `url` text NOT NULL, > `views` int(11) NOT NULL default '0', > `paypal` char(3) NOT NULL default 'No', > `add_date` int(11) NOT NULL default '0', > `exp_date` int(11) NOT NULL default '0', > PRIMARY KEY (`ad_id`) > ) TYPE=MyISAM AUTO_INCREMENT=1 ; > > > > I'm typing this exactly as it appears but it's not working. I also try to > create this table in phpMyAdmin but have a question: > > Field Type > > ad_id SmallInt 5 > > > > Length/Values > > 5 > > > > Charset > > Latin1 > > > > Attributes > > unsigned > > > > Null > > Not_null > > > > Default** > > ????? > > > > Extra > > auto_increment > > > > I'm not sure what to enter for Default**. Can someone tell me what I'm > missing? > > I'm using MySQL5.0alpha w/PHP4.3.4 on W2K3. > > > > Thanks > > -- |- Garth Webb -| |- [EMAIL PROTECTED] -|
signature.asc
Description: This is a digitally signed message part
