Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
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.

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?
[LanX]: D : Oberbefehlshaber
[GotToBTru]: yeah, thats the story I remember. some card the President is supposed to carry around at all times
[GotToBTru]: I suppose the actual details about what is necessary to actually do something is kept fuzzy deliberately
[LanX]: the interview was with the guy who designed the process
[LanX]: in the 70s
[GotToBTru]: so the font on the card is probably NOT Comic Sans
[GotToBTru]: that's a relief
[LanX]: Bruce_G._Blair
[choroba]: as in embossed card?

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (9)
As of 2017-01-20 12:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (174 votes). Check out past polls.