查数据加1问题

[z7758258]

语句:select planhours from project_action_assign
我想现在查出planhours每行数据都加1,怎么写,不能改变数据库里的数据.
而是在显示出来的数据每行都加1.

[paoluo]

select planhours + 1 As planhours from project_action_assign

[paoluo]

select planhours = planhours + 1 from project_action_assign

[paoluo]

兩種方法都行

[dawugui]

select planhours + 1 planhours from project_action_assign