in reply to Multiple SQL statements in DBI
Your question 1 is answered by the likely fact that the statement sequence (as a whole) was either not executed until it parsed correctly, or was run in a transaction, and thus all modifications were rolled back.
2. Executing multiple SQL statements in one ->do call is dependent on the database driver. I wouldn't rely on it.
3. It depends on what the database driver implements. Ask the database vendor about the rationale.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Multiple SQL statements in DBI
by tel2 (Pilgrim) on Sep 07, 2012 at 22:30 UTC | |
by moritz (Cardinal) on Sep 08, 2012 at 08:25 UTC | |
by tel2 (Pilgrim) on Jan 28, 2013 at 04:10 UTC | |
by runrig (Abbot) on Sep 07, 2012 at 22:45 UTC | |
by tel2 (Pilgrim) on Sep 07, 2012 at 22:59 UTC | |
by mje (Curate) on Sep 07, 2012 at 23:59 UTC | |
by tel2 (Pilgrim) on Sep 08, 2012 at 02:25 UTC |
In Section
Seekers of Perl Wisdom