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 v/r -Mike