Mysql with table field
Copy the code below:
Update the article set B=A;
But copy the last in 500 cases of

Or copy ID 5000

Refer how change, right

CodePudding user response:

Where id> 5000
Or
Where id in (select id from the table order by id desc limit 500).