I Need a rather simple update query.
Now I am getting new value , e.g 5600 ( that's bigger than 1st row in the table )
so I need update query for UPDATE a minimal row with this one i.e "Ronald 3000"
New table should look:
That's look really simple , but I am not experienced in sql so much.
SET score = 5600
WHERE name = 'Ronald'
BY score ASC
Hopefully you only have one ronald in the table.