Keeps saying "no database selected"
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
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.