How can I insert values into a table, using a subquery with more than one result?

by

You want:

insert into prices (group, id, price)
select 
    7, articleId, 1.50
from article where name like 'ABC%';

where you just hardcode the constant fields.

More Related Contents:

  1. Join vs. sub-query
  2. Solutions for INSERT OR UPDATE on SQL Server
  3. Inserting multiple rows in a single SQL query? [duplicate]
  4. How do I use an INSERT statement’s OUTPUT clause to get the identity value?
  5. SQL Server: Is it possible to insert into two tables at the same time?
  6. SQL Joins Vs SQL Subqueries (Performance)?
  7. Difference between CTE and SubQuery?
  8. updating table rows in postgres using subquery
  9. Does SparkSQL support subquery?
  10. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  11. subquery in FROM must have an alias
  12. PostgreSQL multi INSERT…RETURNING with multiple columns
  13. Return pre-UPDATE column values using SQL only
  14. Can you access the auto increment value in MySQL within one statement?
  15. How to delete from select in MySQL?
  16. Difference between Subquery and Correlated Subquery
  17. SQL speed up performance of insert?
  18. SQL Server: Cannot insert an explicit value into a timestamp column
  19. SQL Server 2008 – Help writing simple INSERT Trigger
  20. Export specific rows from a PostgreSQL table as INSERT SQL script
  21. postgresql: INSERT INTO … (SELECT * …)
  22. Oracle insert if row does not exist
  23. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  24. Nested select statement in SQL Server
  25. Postgres Error: More than one row returned by a subquery used as an expression
  26. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  27. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  28. SQL – Inserting a row and returning primary key
  29. How do I perform update query with subquery in Access?
  30. How to insert Arabic characters into SQL database?

Leave a Comment