Mysql存储过程遍历问题

[ithoney]

一张表user
id name grade time
1 111 null 2012-12-01
2 222 null 2012-12-02
3 333 null 2012-12-01

我根据时间比如2012-12-01，大于这个时间的都搜出来，然后将每个grade字段分别更新和name值一样的！

遍历不会！！！，求解~

[ithoney]

存储过程刚刚接触，~

[chute]

update user set grade = time where id in (select id from user where time > 2012-12-01)

[ithoney]

求解啊求解啊

[ithoney]

引用 3 楼 zhaofei466 的回复:

update user set grade = time where id in (select id from user where time > 2012-12-01)

谢谢

[chute]

引用 4 楼 ithoney 的回复:

引用 3 楼 zhaofei466 的回复:update user set grade = time where id in (select id from user where time > 2012-12-01)谢谢