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
