MySQL Forums
Forum List  »  MySQL Query Browser

Keeps saying "no database selected"
Posted by: Martijn Saly
Date: August 18, 2010 05:53AM

I need to execute this query:

USE bongusta;
UPDATE wp_options
SET option_value = REPLACE(option_value, 'thany.org', 'thany.nl');

But everytime I do, it reports an error "no database selected".
I wonder at which point exactly the database gets UNselected, since I clearly select one.

Workaround is to avoid USE:

UPDATE bongusta.wp_options
SET option_value = REPLACE(option_value, 'thany.org', 'thany.nl');

Working perfectly.
By does it seem to be impossible to use the USE statement?

Query Browser 1.2.17
MySQL 5.1.41
Windows 2008 x64 SP2

Options: ReplyQuote


Subject
Written By
Posted
Keeps saying "no database selected"
August 18, 2010 05:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.