Why am i seeing "truncated incorrect double value" in sql?

Example:

UPDATE users SET id = id + "string value" WHERE name = "John";

This error is triggered when a non-numeric value is used in a numeric context.

Solution:

-- Ensure you are using numeric values in numeric contexts
UPDATE users SET id = id + 1 WHERE name = "John";