mysql更新表记录的前n条数据

1.更新前10条记录

update student set name = '张三' order by id asc LIMIT 10;

2.可控更新页数

update student set name = '张三' where id in (select t.id from (select id from student LIMIT 0,10) t);