How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16681 Views
- I also Faced
- E-Mail Answers
Answer Posted / payal
select * into databasename.<TableName> from (select * from
databasename.<TableName>)
| Is This Answer Correct ? | 10 Yes | 10 No |
Post New Answer View All Answers
Why we use mysqli instead of mysql?
What is mysqli_free_result?
In how many ways we can retrieve data in the result set of mysql using php?
What is mysql root?
How do I select a database in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What is definer in mysql trigger?
What are the three types of queries?
what is database black box testing? : Mysql dba
Does insert statement lock the table?
What is mvcc in mysql?
How do I install mysql workbench?
How to enable or disable a row of a table using MySQL in struts?
Can we rollback truncate in mysql?
How large can a mysql table be?
