Re: Mysql syntax error - phpMyAdmin ??

Hi, No you should not report it to anyone. Reserved words can be used as column names in MySQL (although you shouldn't) provided that they are surrounded by backticks. When you do it in phpMyAdmin, phpMYAdmin is putting everything inside backticks , so that this problem won't be encountered. See: http://www.mysql.com/doc/L/e/Legal_names.html Gurhan ----- Original Message ----- From: "Michael Zornek" <mikezornek@mikezornek.com> To: <php-db@lists.php.net> Sent: Wednesday, July 10, 2002 1:30 PM Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ?? > Twas 7/10/02 12:55 PM, when "Martin Clifford" <MLC1@nrc.gov> 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 me > do it, yet base MySQL will not. > > Should I report it to the phpMyAdmin team? > > ~ 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 >