这里测CompletedNumTest是列字段,orderinfo是表
SELECT IFNULL(CompletedNumTest,0) AS VALUE FROM orderinfo; //这条语句有问题
UPDATE orderinfo SET CompletedNumTest = 0 WHERE ISNULL(CompletedNumTest);
这里测OrderDate是列字段,orderinfo_copy1 是表
UPDATE orderinfo_copy1 SET OrderDate =REPLACE(OrderDate, '.', '-')