Re: mysqldump error (mysql 4.0.14)

2003-09-29 Thread Director General: NEFACOMP
`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 (

Re: mysqldump error (mysql 4.0.14)

2003-09-29 Thread Victoria Reznichenko
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

Re: mysqldump error (mysql 4.0.14)

2003-09-29 Thread Kelley Lingerfelt
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