Does updating a value in a row rewrite the whole

Question

Does updating a value in a row rewrite the whole

row or just the value? I know this might be a stupid question, most likely it will just update the specific column, but I just wanted a confirmation

0

27.07.2021

5 ответов

32 просмотра

Roy Автор вопроса

Ludovic 'Archivist' Lagouardette
That is db engine specific behaviour

Thanks for the reply. What can I search on Google so that I get my answer? I'm looking specifically for MySQL

0

27.07.2021

Ludovic 'Archivist' Lagouardette

Roy
Thanks for the reply. What can I search on Google ...

If you are using InnoDB and if I remember correctly, each value is a different record Searching for that kind of thing on Google may be hard, you may want to search for the developer documentation and for the source code directly

0

27.07.2021

Ludovic 'Archivist' Lagouardette

Roy
Thanks for the reply. What can I search on Google ...

Another way of getting the correct answer would be to rant about it on reddit/stackoverflow stating an obviously wrong answer like you know what you are talking about

0

27.07.2021

Roy Автор вопроса

Ludovic 'Archivist' Lagouardette
Another way of getting the correct answer would be...

😂

0

27.07.2021

Ludovic 'Archivist' Lagouardette · Accepted Answer

Ludovic 'Archivist' Lagouardette

That is db engine specific behaviour

0

27.07.2021

Похожие чаты

Does updating a value in a row rewrite the whole

5 ответов

Похожие вопросы