`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 (
Rusty Wright <[EMAIL PROTECTED]> 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 t
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
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 ta