RENAME TABLE tbl_name TO new_tbl_name[, tbl_name2 TO new_tbl_name2,...] you can find it from MYSQL MANUAL section RENAME TABLE SYNTAX
> (I tried to post this once, but it didn't show up - sorry if > this is a duplicate!) > Can you rename a table? If so, how? > If not, is there an easy query to run to copy a table? > (Preserving the data as well as the structure, of course.) > Couldn't find it in my MySQL on-line manual... > -- > Mark Wilson, Computer Programming Unlimited (cpuworks.com) > Web : http://cpuworks.com Tel: 410-549-6006 > Email: [EMAIL PROTECTED] Fax: 410-549-4408 > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]