MySQL — how's the caching algorithm?

Read here about the fact that you can optimize MySQL by enabling data caching.
Here, for example, I type in console/PHP script SQL query:
SELECT * FROM `users` WHERE `login`='root'
I, for example, will return the result:
'id' => 1,
'login' => 'root',
'email' => '',
'date_reg' => 1231233212,
'reg_ip' =>,
'auth_ip' =>,

When I enter the SQL query:
UPDATE `users` SET `reg_ip`='',`auth_ip`=NULL WHERE `id`=1

These data will be updated in case? Or updates only when I request data using the SELECT statement again?
June 10th 19 at 14:38
1 answer
June 10th 19 at 14:40
not updated

don't worry and just play

Find more questions by tags MySQL