I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
man DBD::mysql
Cheers.
--
Luis Calero Muñoz
$email{luis} = '[EMAIL PROTECTED]'
3:11 AM
To: Andy Cheng
Cc: [EMAIL PROTECTED]
Subject: Re: How to access MySql using Perl. Help
I am new to MySql. I have MySql installed in my Linux PC. How do I
connect
to MySql using Perl script and assign the result of a query to an
array?
Where could I find a sample code? Thank you
, 2002 4:11 AM
To: Andy Cheng
Cc: [EMAIL PROTECTED]
Subject: Re: How to access MySql using Perl. Help
I am new to MySql. I have MySql installed in my Linux PC. How do I
connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql-connect(undef,database,username,'password');
$sql = select blah from blah;
$sth = $dbh-query($sql);
@arr = $sth-fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is other ways
Hello,
I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
Andy
_
Get your FREE
Hello,
I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
Andy
_
Get your FREE
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql-connect(undef,database,username,'password');
$sql = select blah from blah;
$sth = $dbh-query($sql);
@arr = $sth-fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is other ways