<html><head><style type="text/css"></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>#!/usr/bin/perl -w # this PERL script will connect to a remote MySQL database and execute a select statement use DBI; # DBI is available at CPAN.org if you don't have it installed in PERL # DBI Variables my $dbh; # database handle my $sth; # statement handle my $sta; # a statement my @rows; # returned data my $dbHost = "databaseHost"; # put your database host name here my $dbName = "yourDatabaseName"; # put your database name here my $dbUser = "DatabaseUserName"; # put your username here my $dbPasswd = "databasePwd"; # put your database password here # connect to the database $dbh = DBI->connect("dbi:mysql:".$dbName.":".$dbHost, $dbUser, $dbPwd) or die "Can't connect to database: $DBI::errstr\n\n"; $sta = "SELECT col1,col2 from table where item=\"1\" order by key"; $sth = $dbh->prepare($sta) or die "Can't prepare statment: $DBI::errstr\n\n"; $sth->execute or die "Can't execute statment: $DBI::errstr\n\n"; while (@rows = $sth->fetchrow_array() ) { print $rows[0]; print $rows[1]; } </div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"> <div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><hr size="1">De: Franck Y <franck110@gmail.com> Para: For users of Fedora <fedora-list@redhat.com> Enviado: lunes, 13 de octubre, 2008 16:10:06 Asunto: MSQL though a shell <div dir="ltr">Hello guys, I have to query a remote database that run under MSQL and get the result within a shell/perl script ? Does anyone of you did that ? I would not like to purchase a ODBC driver since it is for a project at school Thanks Franck </div> </div></div></div> <hr size=1> ¡Todo sobre Amor y Sexo! La guía completa para tu vida en Mujer de Hoy: http://mx.mujer.yahoo.com/</body></html>