Re^2: Can't Insert Data To Multiple Table With DBI::Mysql

(and, I think, in any database that supports "Structured Query Language"), the "INSERT" statement only works on one table at a time.

Oracle supports INSERT ALL (INSERT ALL INTO A ... INTO B ... INTO C....) and INSERT FIRST.

Perhaps not what you meant, but SQL Server indirectly allows it, via Partitioned Views or Views with INSTEAD OF Triggers. Those, in a sense, extend the original INSERT statement to include multiple tables. Same goes for DB2.

Of course, a trigger can continue inserting into other tables, but that is mot definitely not the same statement.

Comment on Re^2: Can't Insert Data To Multiple Table With DBI::Mysql

Replies are listed 'Best First'.
Re^3: Can't Insert Data To Multiple Table With DBI::Mysql by pakeidoprek (Novice) on Jul 16, 2016 at 14:40 UTC
Yup, MySql doesn't support insert multiple table in one query. so i fix it with if elsif function :) ^_^	[reply]