ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ha a <ahat...@yahoo.com.cn>
Subject how to update a column value by old column value within update statement in ibatis?
Date Wed, 15 Apr 2009 15:53:31 GMT

in fact, in sql, I can write "update foo_table set column=column+1 where name='abc'".
It resets the new value with one sql.

but how can I do that in ibatis with one statement, not by three statements: one gets the
value, then add 1, then set the new value?

BTW, Can I do it by JDBC? 

Thanks in advance.

View raw message