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

    Join Date
    May 2000
    Rep Power

    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";

    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,


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

    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, 05:24 PM
  2. Replies: 1
    Last Post: September 18th, 2003, 04: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, 10:05 AM
  4. Replies: 2
    Last Post: July 14th, 2002, 12:39 AM

IMN logo majestic logo threadwatch logo seochat tools logo