Tag Archives: MYSQL ERROR 1265

ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7

mysql> UPDATE performance_schema. setup_consumers SET ENABLED = ‘OFF’ WHERE NAME LIKE ‘events_transactions%’;

ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7

mysql> show create tableĀ  performance_schema. setup_consumers \G

*************************** 1. row ***************************

Table: setup_consumers

Create Table: CREATE TABLE `setup_consumers` (

`NAME` varchar(64) NOT NULL,

`ENABLED` enum(‘YES’,’NO’) NOT NULL

) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

It turns out that ENABLED is an enumeration type, where only the YES,NO.

mysql> UPDATE performance_schema. setup_consumers SET
ENABLED = ‘NO’ WHERE NAME LIKE ‘events_transactions%’;