mysql的update语句高级用法

update tableName set column=2 where limit 条数;

replace into tableName(id,name) values(1,’abc);

insert into tableName(id,name) on duplicate key update name = ?;