Easiest way to copy a table from one database to another?

by

CREATE TABLE db1.table1 SELECT * FROM db2.table1

where db1 is the destination and db2 is the source

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MyISAM versus InnoDB [closed]
  3. How to select the nth row in a SQL database table?
  4. Compare two MySQL databases [closed]
  5. How should I resolve –secure-file-priv in MySQL?
  6. What does character set and collation mean exactly?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing image in database directly or as base64 data?
  9. Implementation of Levenshtein distance for mysql/fuzzy search?
  10. Storing JSON in database vs. having a new column for each key
  11. Does MySQL ignore null values on unique constraints?
  12. How do I restore a dump file from mysqldump?
  13. What’s the difference between MyISAM and InnoDB? [duplicate]
  14. What effects does using a binary collation have?
  15. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  16. In SQL, is it OK for two tables to refer to each other?
  17. Error renaming a column in MySQL
  18. Mysql database sync between two databases
  19. What’s the best database structure to keep multilingual data? [duplicate]
  20. How to increase MySQL connections(max_connections)?
  21. Does mysql have the equivalent of Oracle’s “analytic functions”?
  22. MySql views performance [closed]
  23. MySQL: LAST_INSERT_ID() returns 0
  24. How does MySQL Auto Increment work?
  25. Calculating a Moving Average MySQL?
  26. How to get size of mysql database?
  27. Can I launch a trigger on select statement in mysql?
  28. What is the difference between SQL and MySQL? [closed]
  29. mysql Failed to read auto-increment value from storage engine
  30. How to store data with dynamic number of attributes in a database

Leave a Comment