I want to copy table contained from one database and insert onto another database table

by

If you want to copy a table from one Database to another database , You can simply do as below. 

CREATE TABLE db2.table LIKE db1.table;
INSERT INTO db2.table SELECT * FROM db1.table;

More Related Contents:

  1. You can’t specify target table for update in FROM clause
  2. Generating a range of numbers in MySQL
  3. How to get next/previous record in MySQL?
  4. How do I make a row generator in MySQL?
  5. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  6. MySQL number of items within “in clause”
  7. Error 1046 No database Selected, how to resolve?
  8. What’s the difference between VARCHAR and CHAR?
  9. Alter a MySQL column to be AUTO_INCREMENT
  10. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  11. single fixed table with multiple columns vs flexible abstract tables
  12. MySQL remove duplicates from big database quick
  13. mysql, iterate through column names
  14. How to delete from select in MySQL?
  15. How to delete Duplicates in MySQL table
  16. How to ORDER BY a SUM() in MySQL?
  17. mySQL Returning the top 5 of each category
  18. Selecting Random Rows in MySQL
  19. Error: The used SELECT statements have a different number of columns
  20. How to Optimize Queries in a Database – The Basics
  21. Any way to achieve fulltext-like search on InnoDB
  22. Create date from day, month, year fields in MySQL
  23. Can I use a MySQL database with an App Engine application
  24. How to combine aggregate functions in MySQL?
  25. How do I list all the columns in a table?
  26. Two single-column indexes vs one two-column index in MySQL?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment