MySQL Forums
Forum List  »  Newbie

Re: Replace one value for another for entire row
Posted by: Peter Brawley
Date: April 09, 2016 06:53PM

> What do I enter in order to do this

update wp_sola_nl_subscribers
set status=1
where status=2;

> & where do I enter it?

In the mysql client program, having issued ...

use dbname;

where dbname is the name of the database in which the wp_sola_nl_subscribers table exists; or in MySQL WorkBench with that database selected.

Options: ReplyQuote


Subject
Written By
Posted
Re: Replace one value for another for entire row
April 09, 2016 06:53PM


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.