Hello All:
    I would like to rename a table if it exists.

The following query
IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak;
fails.

also 

ALTER TABLE IF EXISTS gwcc_members RENAME gwcc_members_bak;
fails.


1)What is the correct syntax?
2)Where is documentation.
I'm using ver. 3.23.41
Thanks very much.
tim
-- 
Tim Johnson <[EMAIL PROTECTED]>
      http://www.alaska-internet-solutions.com
      http://www.johnsons-web.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to