MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?

by 
INSERT INTO Results (People, names )
   SELECT d.id, 'Henry'
   FROM Names f
   JOIN People d ON d.id  = f.id

Combine the static string Henry with your SELECT query.

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. INSERT INTO…SELECT for all MySQL columns
  3. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  4. Recreating a query using INNER JOIN? [duplicate]
  5. Getting the SUM() of claps and at the same time counting bookmarks in one query
  6. MySQL – UPDATE query based on SELECT Query
  7. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  8. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  9. MySQL Query – Records between Today and Last 30 Days
  10. Ordering by specific field value first
  11. MySQL DELETE FROM with subquery as condition
  12. CROSS/OUTER APPLY in MySQL
  13. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  14. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  15. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  16. Checking multiple columns for one value
  17. MySQL difference between two rows of a SELECT Statement
  18. MySQL – How to search for exact word match using LIKE?
  19. MySQL – How to select data by string length
  20. How do I get the first day of the week of a date in mysql?
  21. MySQL error 1241: Operand should contain 1 column(s)
  22. quick selection of a random row from a large table in mysql
  23. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  24. mysql select sum group by date
  25. SELECT query return 1 row from each group
  26. Comma separated string of selected values in MySQL
  27. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  28. MySQL Error: #1142 – SELECT command denied to user
  29. MySQL Select Multiple VALUES
  30. mySQL returns all rows when field=0

Leave a Comment