In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > I was using phpMyAdmin to do an export from one machine to another and on > import I got an error: > > > Error > >=20 > > SQL-query=A0:=A0=20 > >=20 > > CREATE TABLE hospital ( > > id smallint(5) unsigned NOT NULL auto_increment, > > heath_system_id smallint(5) unsigned default NULL, > > name_long tinytext NOT NULL, > > name_short tinytext, > > logo_file_loc text, > > desc text, > > photo text, > > address1 tinytext, > > address2 tinytext, > > city tinytext, > > state tinytext, > > zip smallint(5) unsigned zerofill default NULL, > > phone tinytext, > > repay_percent tinyint(3) unsigned default NULL, > > url text, > > job_page_url text, > > num_nurses smallint(5) unsigned default NULL, > > active enum('yes','no') NOT NULL default 'yes', > > number_of_beds smallint(5) unsigned NOT NULL default '0', > > type tinytext NOT NULL, > > PRIMARY KEY (id), > > KEY zip (zip) > > ) TYPE=3DMyISAM > >=20 > > MySQL said:=20 > >=20 > > You have an error in your SQL syntax near 'desc text, > > photo text, > > address1 tinytext, > > address2 tinytext, > > city ti' at line 7 > > What's the problem??? My db seems to find on the other machine?
DESC is a reserverd word - used with ORDER BY to signify DESCending order. -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
