MySQL Insert & Joins

by

You can INSERT … SELECT with mysql, which is probably what they mean. For example:

INSERT INTO tableNew (col1, col2)
  SELECT tbl1.col1, tbl2.col2
  FROM tbl1 JOIN tbl2

More Related Contents:

  1. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. How can I do three table JOINs in an UPDATE query?
  4. How to do a batch insert in MySQL
  5. MySQL: Quick breakdown of the types of joins [duplicate]
  6. MySQL update table based on another tables value
  7. Required to join 2 tables with their FKs in a 3rd table
  8. MySQL join with where clause
  9. LAST_INSERT_ID() MySQL
  10. Why does MySQL report a syntax error on FULL OUTER JOIN?
  11. conditional join in mysql
  12. MYSQL Select MAX Date inside a join statement
  13. CROSS/OUTER APPLY in MySQL
  14. Mixing ANSI 1992 JOINs and COMMAs in a query
  15. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  16. a count for each join – optimisation
  17. MySql Count cannot show 0 values
  18. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  19. BULK INSERT in MYSQL
  20. How to insert data to MySQL with auto-incremented column(field)?
  21. MySQL JOIN with LIMIT 1 on joined table
  22. How to insert values in table with foreign key using MySQL?
  23. Laravel join with 3 Tables
  24. mySQL – Create a New Table Using Data and Columns from Three Tables
  25. How to join two tables using a comma-separated-list in the join field
  26. Mysql select where not in table
  27. When to use a left outer join?
  28. MySQL optimizing INSERT speed being slowed down because of indices
  29. MySQL cartesian product between two SELECT statements
  30. Insert and set value with max()+1 problems

Leave a Comment