mysql list all db name

[Alexandre Jaquet]

Hi could anyone let me know how to list all database name of a mysql server

thx in advance

 

[Sherm Pendley]

Hi could anyone let me know how to list all database name of a mysql
server

Have a look at the DBI module on CPAN.

sherm--

 

[Michael Korte]

Alexandre Jaquet wrote:

#connect your dbh, then :
$dbh->prepare("show databases");
$dbh->execute();
# then you can fetch your result.

HTH
Michael

 

[Alexandre Jaquet]

Michael Korte a écrit :

#connect your dbh, then :
$dbh->prepare("show databases");
$dbh->execute();
# then you can fetch your result.

HTH
Michael

thx =)