RE: perl dbi and mysql question

2002-11-08 Thread Shon Stephens
bject: RE: perl dbi and mysql question Of course, you could have also used: $stmt = $db->prepare("show databases"); Peter <^_^> -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:50 AM To: Shon Stephens; &#x

RE: perl dbi and mysql question

2002-11-08 Thread Grigor, Peter
Of course, you could have also used: $stmt = $db->prepare("show databases"); Peter <^_^> -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:50 AM To: Shon Stephens; '[EMAIL PROTECTED]' Subject: RE

Re: perl dbi and mysql question

2002-11-08 Thread stibs-pi
No clue of dbi/dbd but the query SHOW DATABASES does what it tells. STIBS - Original Message - From: "Shon Stephens" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 3:44 PM Subject: perl dbi and mysql question > i am using perl db

RE: perl dbi and mysql question

2002-11-08 Thread Shon Stephens
eureka! i found it! @dbs = $dbh->func('_ListDBs'); -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:45 AM To: '[EMAIL PROTECTED]' Subject: perl dbi and mysql question i am using perl dbi with dbd::m

perl dbi and mysql question

2002-11-08 Thread Shon Stephens
i am using perl dbi with dbd::mysql. i know that using the dbi function, $dbh->tables (), will list all the tables in a database. is there a function that will show all the databases on a server? thanks, shon - Before posting, pl