MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Update column2 on all lines automatically to Y, when column1 is unique and column2 is N
Posted by: Jose Almeida
Date: June 21, 2018 03:00PM

Hi PB,

Thank you for your effort.

That didn't do it.

This is the situation:

key
nume_users enti_users flag_users
1 100 Y
2 101
3 102 Y
4 101
5 101
6 104
7 103
8 103
9 104
10 105 Y

The sentence should only update to Y the flag_users column of records 1, 3 and 10 because they are the ones where enti_users is unique.

This table has about 600 records to check, it is not an impossible to do manual operation.

Sorry for all the trouble,

Thanks again.
JA

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.