`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