in reply to Re^2: Multiple SQL statements in DBI
in thread Multiple SQL statements in DBI

It's the mysql client library C API that introduces the limitation:

Executes the SQL statement pointed to by the null-terminated string stmt_str. Normally, the string must consist of a single SQL statement without a terminating semicolon (“;”) or \g.

Special steps must be taken to allow execution of multiple statements, and seems to be new in version 5.0.

The Postgresql C API doesn't follow that model, but makes another interesting remark:

Note however that the returned PGresult structure describes only the result of the last command executed from the string

which makes it less useful to run multiple statements in a single API call.

Replies are listed 'Best First'.
Re^4: Multiple SQL statements in DBI
by tel2 (Pilgrim) on Jan 28, 2013 at 04:10 UTC
    Months later...

    Thanks for that, moritz.  Just noticed your post recently.

    tel2