DROP TABLE IF EXISTS tbl_test;
CREATE TABLE tbl_test(a int, b int);
DROP TABLE IF EXISTS tbl_test2;
CREATE TABLE tbl_test2(a int, b int);
RENAME TABLE
tbl_test TO tbl_test1,
tbl_test2 TO tbl_test3;
Thursday, January 21, 2010
Rename multiple tables in MySQL
at 5:56 AM
Labels: MySQL, MySQL Query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment