You are confusing shell commands with SQL. An SQL client needs to establish a connection with the db to execute the SQL instructions.

What version of perl are you talking about? DBI is conservatively written and so is not particularly fussy about perl version. If you mean perl4, that doesn't support modules at all. Look around for a binary called perl5, if that is the case.

You should insist on obtaining DBI and its DBD::mysql driver. You can install those in a private directory, but presumably you are doing this for others to use, and so a system installation will be needed.

If your work really has so little support that you can't obtain that, you can kluge up something with system calls to the 'mysql' client, perhaps in batch mode. That is a highly distasteful option.

Update: The current DBI (v1.33) requires perl 5.005_03. Checking what earlier versions are available - It appears that version 1.20 and previous work with 5.004; all say they prefer 5.004_04 or later.

After Compline,
Zaxo

In reply to Re: perl and sql by Zaxo
in thread perl and sql by suekawar

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.