update databasetest.table1 set num1 = round(num1,2) WHERE num1<>'NaN' and num1<0;
当把数字以字符串形式存储时,查询数据时条件中又包含数字范围,先过滤掉非数字字符串,如上面的字符串'NaN',后面再加范围条件,顺序不可颠倒,否则会报错:1292 Truncated incorrect DOUBLE value:XXX(非数字的字符串)
update databasetest.table1 set num1 = round(num1,2) WHERE num1<>'NaN' and num1<0;
当把数字以字符串形式存储时,查询数据时条件中又包含数字范围,先过滤掉非数字字符串,如上面的字符串'NaN',后面再加范围条件,顺序不可颠倒,否则会报错:1292 Truncated incorrect DOUBLE value:XXX(非数字的字符串)