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`

v/r
-Mike