Insert data into table with result from another select query

by

If table_2 is empty, then try the following insert statement:

insert into table_2 (itemid,location1) 
select itemid,quantity from table_1 where locationid=1

If table_2 already contains the itemid values, then try this update statement:

update table_2 set location1=
(select quantity from table_1 where locationid=1 and table_1.itemid = table_2.itemid)

More Related Contents:

  1. MySQL INSERT INTO … VALUES and SELECT
  2. MySQL error 1241: Operand should contain 1 column(s)
  3. MySQL – insert data from another table merged with constants
  4. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  5. How to set initial value and auto increment in MySQL?
  6. quick selection of a random row from a large table in mysql
  7. How to do a batch insert in MySQL
  8. MySQL: is a SELECT statement case sensitive?
  9. LAST_INSERT_ID() MySQL
  10. Combine Multiple child rows into one row MYSQL
  11. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  12. How to get an age from a D.O.B field in MySQL?
  13. How to copy a row and insert in same table with a autoincrement field in MySQL?
  14. MySQL Error 1264: out of range value for column
  15. Importing a CSV to MySQL with different date format
  16. How to insert values in table with foreign key using MySQL?
  17. Field ‘id’ doesn’t have a default value?
  18. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  19. How do I get the first day of the week of a date in mysql?
  20. quick selection of a random row from a large table in mysql
  21. insert data from one table to another in mysql
  22. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  23. mysql select sum group by date
  24. Comma separated string of selected values in MySQL
  25. MySQL Select Query – Get only first 10 characters of a value
  26. How to use Table output from stored MYSQL Procedure
  27. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  28. Incorrect integer value: ” for column ‘id’ at row 1
  29. MySQL cartesian product between two SELECT statements
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment