Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^3: Multiple SQL statements in DBI

by chacham (Deacon)
on Sep 07, 2012 at 23:21 UTC ( #992405=note: print w/ replies, xml ) Need Help??


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

I'm not sure where CLI driver is,

CLI is the Call Level Interface. when you type in mysql and get a prompt, that program is using the CLI to communicate with the database. (At least that how everyone else does it.) In a sense, you are never "in" the database, you are always making calls to it instead. But those nice people at mysql have a nifty program to make basic calls for you, behind the scenes, per se.

When you echo multiple statement in a client program, it sends each statement separately through the CLI. That's two statements, two cursors, et al. It hides it from you, but there are two calls. When you are using DBI, you are taking control of when to call the CLI (via DBI, which does it for you), so when you have two statements, the CLI gets called only once, and it doesn't support multiple statements in the same batch.


Comment on Re^3: Multiple SQL statements in DBI
Re^4: Multiple SQL statements in DBI
by tel2 (Scribe) on Sep 08, 2012 at 02:26 UTC
    Thanks again chacham.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2014-04-20 02:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (485 votes), past polls