'Issue in Mysql Database Update Record Reflection in select query

I have applied mysql (adminer) edit record and click on save. I have got item updated successfully. But when I try to see data using select query, but I got old data. I have tried 5 to 6 times same things. After 6 or 7 trials I got proper data.

Same query works every time but at that day I have faced this issue.

UPDATE category SET id = '5', category_name = 'Category B', capacity = '290000.00', scheme_id = '2', created = '2020-10-19 00:00:00', updated = '2020-10-19 00:00:00' WHERE id = '5';



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source