PROGRAMMING: Pwede po ba mag query insert ng data in multiple table sa mysql?
November 13, 2022 • BY MARK MORALES
• insert data
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