How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16693 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
How we can create index in mysql?
How to see table's field formats or description of table .
How to get a version of mysql?
How does mysql store data?
What is a definer?
What are the method you will follow while sql installing
what is the default port for mysql server? : Mysql dba
What are ddl statements in mysql?
What is relational database in mysql?
can you elaborate on blob and text in mysql? : Mysql dba
Where is the mysql database stored?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
Is mysql connect deprecated?
What is the difference between having and where clause in mysql? Explain
