1。update tablename set column1='value',column2='value' where condition
2。update tablename set(column1,column2)=(select column1,column2 from tablename where condition) where condition
另外一个参考为：http://www.javaeye.com/topic/192926
