Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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

by Solo (Deacon)
on Jan 31, 2005 at 16:31 UTC ( [id://426647]=note: print w/replies, xml ) Need Help??


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

...I don't want to do is use a SHOW TABLES and iterate through the results...

SHOW TABLES accepts a LIKE clause, though it's not clear what versions support it.

The more Perlish way might be to use one of the DBIx:: modules like DBIx::DBSchema to check if each table exists.

--Solo

--
You said you wanted to be around when I made a mistake; well, this could be it, sweetheart.
  • Comment on Re: Best Perlish way to test if a mysql table exists?

Replies are listed 'Best First'.
Re^2: Best Perlish way to test if a mysql table exists?
by Anonymous Monk on Mar 28, 2013 at 18:32 UTC
    Short, sweet, not complicated, no additional questions, etc.., = what I was looking for. Thanks.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://426647]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (3)
As of 2024-04-20 03:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found