RE: Rename/Copy a Table????

[Jennifer Goodie]

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]

Re: Rename/Copy a Table????

[ag315]

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]