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

最新推荐文章于 2024-10-02 18:00:01 发布

lwei_998

最新推荐文章于 2024-10-02 18:00:01 发布

阅读量2.6k

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/lwei_998/article/details/79755717

版权

MySQL 专栏收录该内容

123 篇文章 1 订阅

订阅专栏

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)

原来ENABLED是个枚举类型，这里只允许YES,NO.

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