Home >Database >Mysql Tutorial >Optimization-mysql adds the fields that meet the conditions,
mysql optimization database
The ones with s are judgment columns, and the ones without are numeric columns. Judge whether s_1605 to s_1702 is 0 or 1, and add all the judgment columns that are 0,
I can’t see clearly in your picture, and the problem is not clearly described.