desc is a key word. :-\ -----Original Message----- From: Michael Zornek [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I was using phpMyAdmin to do an export from one machine to another and on import I got an error: > Error > > SQL-query : > > 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=MyISAM > > MySQL said: > > 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? ~ Mike -- Mike Zornek | Project Leader Apple Student Developers The Insanely Great Site with the Insanely Long URL http://www.applestudentdevelopers.org Personal Site: http://www.mikezornek.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php