MySQL Forums
Forum List  »  Delphi

MySQL, When, Where clause
Posted by: Jim Sawyer
Date: August 14, 2020 12:06PM

I have a MySQL table, Records with about four million records. In the table are thousands of groups having the same Invno (integer) and Related (integer) values. Each of these values has a Clinno (integer) value for the first record in that group, but for the other records in the group, Clinno is 0. I need to update the table so that all records in all groups have the proper Clinno value in all records in the group, not just the first record. How can I construct a "update,case,when,where clause" to get this done?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
MySQL, When, Where clause
August 14, 2020 12:06PM


Sorry, only registered users may post in this forum.

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.