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
What is the latest version of php and mysql?
What is auto increment in mysql?
Which command is used to view the content of the table in mysql?
How can you retrieve a particular number of records from a table?
What are date and time data types?
What is 'mysqldump'?
What language is used in mysql?
How do I flush privileges in mysql?
What, if a table has one column defined as TIMESTAMP?
How to get the current date in mysql?
What is the use of procedure in mysql?
How can I see connections in mysql?
What is the insert?
What mysql -u john -p command does?
Why to use char instead of varchar in the database?