FIXED Re: mysql syntax

\_ SMTP quoth Mike Starke on 12/3/2002 12:08 as having spake thusly:
\_
\_ On Tue, Dec 03, 2002 at 12:00:41PM -0500, Mike Starke wrote:
\_ /_I am trying to use the mysql client to rename some tables
\_ /_which have spaces in the table name. I have tried double
\_ /_quotes, single quotes, etc, with no luck. I suspect
\_ /_I am not escaping the space correctly. Can anyone lend
\_ /_me the syntax?
\_ /_
\_ /_show tables;
\_ /_| My Table |
\_ /_
\_ /_alter table "My Table" rename my_table <- does not work
\_
\_ You must use a "backtick" `My Table`

Alternatively, flush the tables, optionally (YMMV if you don't) shut
down mysql, and do a file system move on the tables.

David