Marvin Cummings writes:
>I attempt to create this table from the command line and get the following
>error:
Marvin,
the use of the "'" [single quote] appears to be your problem. I've
been able to create the table on 4.0.18 using the following syntax:
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 ;
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
