MySQL – insert data from another table merged with constants

by

Use an INSERT ... SELECT statement where you are selecting constant values as well as data from products_temp:

INSERT INTO products (product_data, vendor_id)
    SELECT data, '1' FROM products_temp

More Related Contents:

  1. MySQL INSERT INTO … VALUES and SELECT
  2. MySQL error 1241: Operand should contain 1 column(s)
  3. Insert data into table with result from another select query
  4. Recreating a query using INNER JOIN? [duplicate]
  5. MySQL – UPDATE query based on SELECT Query
  6. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  7. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  8. MySQL Query – Records between Today and Last 30 Days
  9. Ordering by specific field value first
  10. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  11. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  12. INSERT INTO…SELECT for all MySQL columns
  13. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  14. Checking multiple columns for one value
  15. BULK INSERT in MYSQL
  16. MySQL difference between two rows of a SELECT Statement
  17. How to insert data to MySQL with auto-incremented column(field)?
  18. MySQL – How to search for exact word match using LIKE?
  19. MySQL – How to select data by string length
  20. MySQL Insert & Joins
  21. How to add a where clause in a MySQL Insert statement?
  22. SELECT query return 1 row from each group
  23. Comma separated string of selected values in MySQL
  24. SQL query to check if a name begins and ends with a vowel
  25. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  26. MySQL Error: #1142 – SELECT command denied to user
  27. MySQL optimizing INSERT speed being slowed down because of indices
  28. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  29. Incorrect integer value: ” for column ‘id’ at row 1
  30. MySQL cartesian product between two SELECT statements

Leave a Comment