#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    2
    Rep Power
    0
    Hi,

    We would like to generate a mysql select query from a perl script.
    Unfortunately we are facing problems in connecting mysql from the perl script.
    We think the connection part of the script should be something like this:

    $DSN = "DBI:mysql:cac:localhost";
    $dbh = MySql->Connect('localhost','cac');



    $SQL= "SELECT * FROM artigos where Familia='VASOS';" or die "erro ao seleccionar Queryn";
    $dbh->Query($SQL);



    Our server name is “Ceramicarte”. Our database name is “cac” (you prepared it for us two weeks ago and we already create a
    table and filled it with data).
    Can you help us with this problem? Do we need to provide our password somewhere on the script?

    Best regards,

    LSoares

  2. #2
  3. No Profile Picture
    chinnavi
    Guest
    Devshed Newbie (0 - 499 posts)
    hai

    your ? is not clear!
    what do u want to do exactly?

    if you want to connect to MySQL
    thro perl it is so Easy...
    *Through DBI*

    Read some perl DBI tutorials.


    ------------------

Similar Threads

  1. mysql commands from shell script problem
    By amitranjan35 in forum MySQL Help
    Replies: 0
    Last Post: September 26th, 2003, 06:24 PM
  2. Replies: 1
    Last Post: September 18th, 2003, 05:18 PM
  3. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 11:05 AM
  4. Replies: 2
    Last Post: July 14th, 2002, 01:39 AM

IMN logo majestic logo threadwatch logo seochat tools logo