Mysql insert into 2 tables

by

It’s not possible with one query as INSERT can only insert data to one table in mysql. You can either

  1. write this as two queries and execute them as a batch
  2. create a stored procedure that would execute two insert command

You can wrap those inserts in transaction if you need to make sure that both queries will write the data.

More Related Contents:

  1. MySQL Conditional Insert
  2. Get the new record primary key ID from MySQL insert query?
  3. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  4. LAST_INSERT_ID() MySQL
  5. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  6. MySql Table Insert if not exist otherwise update
  7. Increment a database field by 1
  8. Prevent auto increment on MySQL duplicate insert
  9. MySQL trigger On Insert/Update events
  10. How to copy a row and insert in same table with a autoincrement field in MySQL?
  11. MySQL Error 1264: out of range value for column
  12. BULK INSERT in MYSQL
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. MySQL trigger to update a field to the value of id
  15. How to insert data to MySQL with auto-incremented column(field)?
  16. Field ‘id’ doesn’t have a default value?
  17. MySQL INSERT INTO … VALUES and SELECT
  18. insert data from one table to another in mysql
  19. MySQL Insert & Joins
  20. How to add a where clause in a MySQL Insert statement?
  21. Reserved word in column name – insert into MySQL [duplicate]
  22. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  23. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  24. MySQL – insert data from another table merged with constants
  25. Insert data into table with result from another select query
  26. MySQL optimizing INSERT speed being slowed down because of indices
  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. “Unknown column in ‘field list'”, but column does exist
  30. Insert and set value with max()+1 problems

Leave a Comment