How we can copy one table data into another table whose name
same as table but in differ database

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


Please Help Members By Posting Answers For Below Questions

What is procedures in mysql?

486


What is select query in mysql?

449


What are mysql functions?

473


Is mysql easy to learn?

464


Is sql similar to mysql?

462






Where the database is stored in mysql?

471


How to connect html form to mysql database using php?

465


What are the 'mysql' command line arguments?

496


Can't connect mysql server on localhost?

476


Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

508


What are the steps involved in query processing?

462


State the differences between mongodb and mysql.

500


How do I zip a file in mysql?

511


How to use sum function in where clause in mysql?

423


Is pdo faster than mysqli?

451