Re: Rename/Copy a Table????
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]
RE: Rename/Copy a Table????
You can rename a table by using the alter syntax http://www.mysql.com/doc/en/ALTER_TABLE.html ALTER TABLE tbl_name RENAME [TO] new_tbl_name > -Original Message- > From: Mark Wilson [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 4:41 PM > To: Mysql Mailing List > Subject: Rename/Copy a Table > > > (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]
