Name
DBI::data_sources
Synopsis
@data_sources = DBI->data_sources($dbd_driver);
DBI::data_sources
takes the name of a DBD module
as its argument and returns all of the available databases for that
driver in a format suitable for use as a data source in the
DBI::connect
function. The program will die with
an error message if an invalid DBD driver name is supplied. In the
current Msql-Mysql modules distribution, the driver for mSQL is named
`mSQL’ and the driver for MySQL is named
`mysql’.
Example
use DBI; my @msql_data_sources = DBI->data_sources('mSQL'); my @mysql_data_sources = DBI->data_sources('mysql'); # Both DBD::mSQL and DBD::mysql had better be installed or # the program will die. print "mSQL databases:\n" . join("\n",@msql_data_sources) . "\n\n"; print "MySQL databases:\n" . join("\n",@mysql_data_sources) . "\n\n";
Get MySQL and mSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.