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
Which is better sqlite or mysql?
How can you import tables from a sql file into a database by using the mysql client?
How to returns the columns and column information pertaining to the designated table.
What is the use of mysql workbench?
What is pdo :: fetch_assoc?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
What is the difference between char and varchar?
What is row level locking in access?
Can we join 3 tables in mysql?
What are the difference between and myisam and innodb?
How to declare variable in mysql trigger?
How do you restart mysql?
How do I tune a mysql query?
How do I assign a variable in mysql?
What is required to create mysql database?