locked
can i insert data into multiple tables using single query in mysql? RRS feed

  • Question

  • User-1598965247 posted

    can i insert data into multiple tables using single query in mysql?

    Sunday, May 20, 2012 1:09 PM

All replies

  • User-1052995518 posted

    Hi  Heyitsme

    Yes you can, separate commands with semicolon (;).

    Good Luck.

    Sunday, May 20, 2012 1:47 PM
  • User1320101480 posted

    If you want all statements to execute or if one fails, none should execute then use Transactions.

    Sunday, May 20, 2012 1:52 PM