in reply to DBD and a MySQL query with a SET @num line

There is a parameter in DBD::mysql's connect called mysql_multi_statements. Perhaps it needs to be enabled.

"As of MySQL 4.1, support for multiple statements seperated by a semicolon (;) may be enabled by using this option. Enabling this option may cause problems if server-side prepared statements are also enabled."

  • Comment on Re: DBD and a MySQL query with a SET @num line