HuyPV
Saturday, October 10, 2009
# Copy table structure
create table db2.table2 like db1.table1;
# Copy table data
insert into db2.table2 select * from db1.table1;
Title:
How to copy table data
Description:
# Copy table structure create table db2.table2 like db1.table1; # Copy table data insert into db2.table2 select * from db1.table1;
...
Rating:
4