RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??

Sorry, [desc] won't work either. :-( -----Original Message----- From: Chip Atkinson [mailto:chip@outputservices.com] Sent: Wednesday, July 10, 2002 10:54 AM To: Michael Zornek Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ?? I can't say for sure, but perhaps "desc" is a reserved word, short for describe. What happens if you say something like "description"? Chip On Wed, 10 Jul 2002, Michael Zornek wrote: > 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