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 mysql good for?
What does it mean to be case sensitive?
How do I get a list of table names in mysql?
What is mysql used for?
what is constraints?
How do I change mysql password?
Explain about the architecture of MYSQL?
What do you understand by mysql terminal?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
How can an index be declared in mysql?
How do you connect MySQL database with PHP?
How do I restart mysql on windows?
What is the use of mysqli_num_rows?
What is data types in mysql?
How would you enter characters as hex numbers?