求update语句
用 select date from table where (id between '1' and '10')找到日期全为2010-1-1
希望用update把date全改为2011-1-1
怎么写?
希望用update把date全改为2011-1-1
怎么写?
作者: alfred123 发布时间: 2011-06-15
update table set date = "2011-1-1" where id between '1' and '10'
作者: aspwebchh 发布时间: 2011-06-15
引用 1 楼 aspwebchh 的回复:
update table set date = "2011-1-1" where id between '1' and '10'
update table set date = "2011-1-1" where id between '1' and '10'
改下：
SQL code
update table set date = '2011-1-1' where id between '1' and '10'
作者: jxqn_liu 发布时间: 2011-06-15
SQL code
select dateadd(yy,1,date) from table where (id between '1' and '10')
作者: cd731107 发布时间: 2011-06-15
SQL code
update table set date = '2011-1-1' where id between '1' and '10'
作者: fredrickhu 发布时间: 2011-06-15
SQL code
select date from table where (id between '1' and '10') and datediff(day,'2010-1-1',date)=1 update table set date = '2011-1-1' where (id between '1' and '10') and datediff(day,'2010-1-1',date)=1
作者: yibey 发布时间: 2011-06-15