MySQL INSERT INTO … VALUES and SELECT

by

Use an insert ... select query, and put the known values in the select:

insert into table1
select 'A string', 5, idTable2
from table2
where ...

More Related Contents:

  1. MySQL error 1241: Operand should contain 1 column(s)
  2. Recreating a query using INNER JOIN? [duplicate]
  3. What is better subquery vs literal on IN clause in mysql
  4. SQL query return data from multiple tables
  5. quick selection of a random row from a large table in mysql
  6. How to do a batch insert in MySQL
  7. MySQL SELECT only not null values
  8. Ordering by specific field value first
  9. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  10. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  11. How to copy a row and insert in same table with a autoincrement field in MySQL?
  12. Checking multiple columns for one value
  13. MySQL Error 1264: out of range value for column
  14. How do I get the ID of multiple inserted rows in MySQL?
  15. How to insert data to MySQL with auto-incremented column(field)?
  16. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  17. How to select one row randomly taking into account a weight?
  18. quick selection of a random row from a large table in mysql
  19. Compare only day and month with date field in mysql
  20. SELECT query return 1 row from each group
  21. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  22. MySQL INNER JOIN select only one row from second table
  23. MySQL Select Query – Get only first 10 characters of a value
  24. MySQL – insert data from another table merged with constants
  25. Insert data into table with result from another select query
  26. How to SELECT by MAX(date)?
  27. MySQL optimizing INSERT speed being slowed down because of indices
  28. MySQL: Insert datetime into other datetime field
  29. “Unknown column in ‘field list'”, but column does exist
  30. Insert and set value with max()+1 problems

Leave a Comment