I am cleaning my db of obsolete values, and I want to set a column is_promotion to null :
set is_promotion = null
where is_promotion = 0
Data Truncation error occurred on a write of column 0Data was 0 bytes long and 0 bytes were transferred.
`is_promotion` varchar(10) DEFAULT NULL,
The problem is that
is_promotion is a
varchar, so you should use:
WHERE is_promotion = '0'