Connecting mysql from the perl script

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

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.


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