整数:
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);
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)