Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Problems with MySQL - "No Database Selected"

by boo_radley (Parson)
on May 09, 2002 at 20:47 UTC ( #165501=note: print w/ replies, xml ) Need Help??


in reply to Problems with MySQL - "No Database Selected"

Add a "CONNECT whatever_your_database_is_named" and you should be ok.
Sounds like your dba didn't choose a default database, if that's possible in mysql...

not perl related, and minimally only database related... pick up a primer and enjoy.
update oops, chromatic's correct. Teach me to write a node while I'm in a cranky mood. mea culpa.


Comment on Re: Problems with MySQL - "No Database Selected"
Re: Re: Problems with MySQL - "No Database Selected"
by ninja-joe (Monk) on May 09, 2002 at 21:06 UTC
    I did this and it flagged an SQL syntax error: Did I add it to the right spot?
    $sth = $dbh->prepare("CONNECT default; SELECT section, content FROM we +bdata WHERE section=home")

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (10)
As of 2014-11-26 17:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (172 votes), past polls