Hello HeidiSQL community!
I am attempting to modify some database data for a video game and I am wondering if it is possible, with the latest version of HeidiSQL, to subtract the same value from all of the columns in a specific row.
To be more specific, the database container I wish to modify contains 8 rows (left to right) that each house 4,960 columns (top to bottom) of data. They are all simple integers. I do not wish to modify the data in row 1, row 2 and row 3. For rows 4 through 8, I want to subtract 3 from all of the values in all 4,960 columns for these 5 specific rows. Is there any way to do this, regardless of I can do multiple rows at once or each row separately? I do hope so, as it would be quite the undertaking to manually subtract 3 from each of the columns in those rows. That would be 24,800 manual adjustments.
Thank you for taking the time to read and reply!