How we can copy one table data into another table whose name
same as table but in differ database
Answer Posted / jayanthi reddy
create table tablename select * from databasename.tablename
i'm expecting this will work. if anything wrong correct it
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
How internally data stores in MyISAM and INNODB table types?
What is definer in mysql?
Is foreign key indexed mysql?
What do ddl, dml, and dcl stand for?
How do I update a variable in mysql?
Can we join 3 tables in mysql?
What is the purpose of using a heap table?
How to delete an existing column in a table?
How to run 'mysql' commands from a batch file?
How can you filter the duplicate data while retrieving records from the table?
How many rows we can insert in a mysql table?
How do I edit a database in mysql workbench?
What is mysqladmin flush hosts?
How do I change a procedure in mysql?
What is use of mysql?