Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re^3: Multiple SQL statements in DBI

by moritz (Cardinal)
on Sep 08, 2012 at 08:25 UTC ( #992445=note: print w/ replies, xml ) Need Help??


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.


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

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

    tel2

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://992445]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (9)
As of 2015-07-28 10:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (254 votes), past polls