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?


Options: ReplyQuote

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

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.