PROGRAMMING: Pwede po ba mag query insert ng data in multiple table sa mysql?

Pwede po ba mag query insert ng data in multiple table sa mysql?

Answers: 

Yaah ppssible i do multiple insert query 😂

Insert into table1

Insert into table 2

Insert into table 3 😂.

1. Pwede gamit ka lang semi colon every query.

2. Gamit stored procedure

You can use database transaction para pwede mong icancel lahat ng previous actions mo pag nagfail yung isa.

https://dev.mysql.com/doc/refman/8.0/en/commit.html

Possible i do multiple queries in one condition but not a good practice 🤣

pwede naman separate by new line or by semicolon