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
posts - 15, comments - 15, trackbacks - 0, articles - 2
Copyright © 冰江独行
