in reply to Re^2: Multiple SQL statements in DBI
in thread Multiple SQL statements in DBI
I don't think DBI prevents anything. It passes the text you give it to the database to parse. If the mysql command line takes multiple statements, then the command line tool is likely parsing separate statements. Likewise, in Oracle, you can pass multiple SQL statements to sqlplus, but not to DBI, because sqlplus does some parsing of its own.
I do see that the latest version of DBD::mysql supports multiple result sets. You might want to look into that.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^4: Multiple SQL statements in DBI
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