tered.
See:
http://www.mysql.com/doc/L/e/Legal_names.html
Gurhan
- Original Message -
From: "Michael Zornek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 1:30 PM
Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??
> Twas 7/10
Twas 7/10/02 12:55 PM, when "Martin Clifford" <[EMAIL PROTECTED]> said:
> DESC is a reserved word in SQL, standing for Descending Order. That is why
> you can't use it as a table column name.
Ok, that makes sence - thanks!
Although I find it a bit curious that building the DB in phpMyAdmin let
On Thursday 11 July 2002 01:00, Ryan Jameson (USA) wrote:
> Sorry, [desc] won't work either. :-(
Try `desc`.
But it's best not to use 'desc' at all, it will save you confusion in the long
run.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
Sorry, [desc] won't work either. :-(
-Original Message-
From: Chip Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:54 AM
To: Michael Zornek
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I can't say for sure, but per
DESC is a reserved word in SQL, standing for Descending Order. That is why you can't
use it as a table column name.
HTH
Martin
>>> Michael Zornek <[EMAIL PROTECTED]> 07/10/02 12:49PM >>>
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
> Error
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
Try [desc]
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, July 10, 2002 10:51 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??
desc is a key word. :-\
-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent
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 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_sh