How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16195 Views
- I also Faced
- E-Mail Answers
Answer Posted / jyoti
SELECT *
INTO table_name [IN externaldatabase]
FROM tablename
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Can you tell which of the following where clauses is faster?
How do you say mysql?
How do I download a mysql community server?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
What is mysql primary key?
What is a trigger? How you can create a trigger in mysql?
How can you find out the version of the installed mysql?
What is processlist in mysql?
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
What is difference between mysql and mysql server?
What is a definer?
Can we join 3 tables in mysql?
What is acid in mysql?
What is delimiter in mysql trigger?
How to convert character strings to numeric values?
