`TableNamesOr FieldNames` ----- Original Message ----- From: "Kelley Lingerfelt" <[EMAIL PROTECTED]> To: "Rusty Wright" <[EMAIL PROTECTED]>; "Mysql List" <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 09:10 Subject: Re: mysqldump error (mysql 4.0.14)
> Try putting the name inside of backticks; > > >From the Manual: > 6.1.2 Database, Table, Index, Column, and Alias Names > ----------------------------------------------------------------------- > Note that if the identifier is a restricted word or contains special characters you must always > quote it with a ` (backtick) when you use it: > mysql> SELECT * FROM `select` WHERE `select`.id > 100; > See Section 6.1.7 [Reserved words], page 437. > > KL > > Rusty Wright wrote: > > > I have a user who unfortunately named one of his tables "order". He also > > has table names with a dash in them. mysqldump is unable to dump the > > "order" table and I'm unable to use the ALTER command on it and the tables > > with the dashes in their names to rename them. Is there any way to quote > > the table names so it doesn't treat them as sql commands? > > > > /local_a/servers/mysql/bin/mysqldump: Got error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order READ /*!32311 LOCAL */,order_pricing READ /*!32311 LOCAL when using LOCK TABLES > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]