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.