Re: Creation date of a MySQL DB and table

[Stephen Patterson]

On Friday 12 October 2001 6:37 pm, Mark Pryor wrote:

> At this point I am looking up the MySQL data folder from
> my.ini, then doing a stat on "SomeTable.MYD." This seems
> like a hack.

There's a listtables() method in the Mysql module, *not* the DBD::Mysql

use Mysql;
$dbh_mysql = Mysql->connect('host', 'database', 'user', 'password')
    || die {error("Cannot connect to database: $DBI::errstr")};
@tables = $dbh_mysql->listtables;