Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: How to find MySQL database exist or not

by rcaputo (Chaplain)
on Sep 01, 2011 at 17:46 UTC ( [id://923678]=note: print w/replies, xml ) Need Help??


in reply to How to find MySQL database exist or not

Query MySQL's internal tables for the information: 

1) macbookpoe:~% mysql -BN -e 'select count(1) from information_schema
+.TABLES where TABLE_SCHEMA="test" and TABLE_NAME="moo"'

1

1) macbookpoe:~% mysql -BN -e 'select count(1) from information_schema
+.TABLES where TABLE_SCHEMA="test" and TABLE_NAME="moue"'

0

[download]

--
Rocco Caputo - http://poe.perl.org/ - irc://irc.perl.org/poe

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://923678]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2026-02-08 05:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found
    Notices?
    • hippo‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.