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
