Re^2: Best Perlish way to test if a mysql table exists?

in reply to Re: Best Perlish way to test if a mysql table exists?
in thread Best Perlish way to test if a mysql table exists?

'cause, like I said, there are tens of thousands of tables in the database, and perhaps hundreds of tables in the list - I don't want to bloat this with a lot of extra crunching.

The more I think of it, the more a Perl solution that will trap the "table does not exist" error may be best.

Forget that fear of gravity,
Get a little savagery in your life.

Comment on Re^2: Best Perlish way to test if a mysql table exists?

Replies are listed 'Best First'.
Re^3: Best Perlish way to test if a mysql table exists? by trammell (Priest) on Jan 31, 2005 at 02:17 UTC
I don't think it would be a lot of extra crunching. Maybe a single query to list the tables, which you cache in a local hash. Then check the values in the hash to see if the current table you're querying is in the database. Hardly bloated.	[reply]

In Section Seekers of Perl Wisdom