Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: perl and sql

by OM_Zen (Scribe)
on Feb 28, 2003 at 16:14 UTC ( #239467=note: print w/ replies, xml ) Need Help??


in reply to perl and sql

Hi ,

The select has to be implemented from inside the MySQl and not from the OS and qx[$select_cmd] or backticks or system would only have it run in the OS .

If the administrator does not want to install the DBI then do it youselves in any other directory and access it if that is somehting you can entertain doing or else try invoking

 system " sqlplus $usernm/$passwd\@$sid \@sql_command_in_an_os_file";


This could work in Oracle and there is corresponding MySQL command that invokes the sql prompt and also kicks off the select statement if the select statement can be had in an os file of as an here document in the program itself .But DBI is THE way to do the database's level works


Comment on Re: perl and sql
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://239467]
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: (9)
As of 2014-12-19 20:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (91 votes), past polls