整数：
UPDATE table_name SET int_column_value = int_column_value + 10;UPDATE table_name SET int_column_value = 10 WHERe int_column_value IS NULL;
日期：
UPDATE table_name SET date_column_value = DATEADD(date_column_value, INTERVAL 1 MONTH);
整数：
UPDATE table_name SET int_column_value = int_column_value + 10;UPDATE table_name SET int_column_value = 10 WHERe int_column_value IS NULL;
日期：
UPDATE table_name SET date_column_value = DATEADD(date_column_value, INTERVAL 1 MONTH);
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
