MySQL中 Data truncated for column 'xxx'解决方法

最新推荐文章于 2024-10-02 18:00:01 发布
最新推荐文章于 2024-10-02 18:00:01 发布
阅读量2.6k 收藏 3
点赞数 3
CC 4.0 BY-SA版权
文章标签： 数据库
原文链接：http://www.cnblogs.com/zhouj850/p/10681318.html
本文详细解析了在MySQL数据库中遇到的“数据截断”错误，主要原因是字段长度不足导致的数据插入失败。通过调整字段长度，成功解决了这一问题，确保了数据的正确存储。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

 DATA truncated FOR COLUMN 'description' AT ROW 1

 

 

 

1、错误再现

  • 表中存在null字段
  • 此时，修改表中某字段为主键

这里写图片描述

这里写图片描述

2、解决方法

  • 不允许数据库中出现null字段
  • 不允许数据库中出现null字段
  • 不允许数据库中出现null字段

3、问题原因

这个错误,其实就是插入的数据不合法造成的, 

比如:乱码，超出字段长度，非法字符等, 我这里的插入的数据超出字段长度造成的。。。

当时mysql 数据库中表的字段   description(描述)   VARCHAR(32)，而插入数据的已经超过32，修改为VARCHAR(300)即可

 

转载于:https://www.cnblogs.com/zhouj850/p/10681318.html

【异常】Navicat修改或更新MySQL数据库，提示Data truncated for column ‘字段名‘ at row 1
本本本添哥
03-12 1465
当我们基于现有的MySQL数据库表进行重新数据库设计时，经常会遇到由于字段类型、字段长度或字段是否为空等问题导致的错误。
【异常】MysqlDataTruncation: Data truncation: Incorrect datetime value: ‘xxx‘ for column ‘xxx‘ at row 1
本本本添哥
06-20 601
由于 update_by 字段通常用于记录哪个用户进行了更新操作，它应该是一个字符串类型（如 VARCHAR），而不是日期时间类型（如 DATETIME）。这个错误表明在尝试向数据库的某个表插入或更新数据时，提供给 update_by 字段的值 ‘admin’ 是不正确的日期时间格式。修改错误日期时间类型（如 DATETIME）为字符串类型（如 VARCHAR）即可。
mysql出现Data truncated for column
weixin_34200628的博客
09-13 369
1.首先叙述，描述你自己的问题。 假设你想把同意为空值的勾去掉。。。恰巧数据库中的数据 processed_f 为空没有值。。。。这时候你对数据表结构做更改的时候就会出现Data truncated for column processed_f 的提示。。解决方案即为  给数据库中的字段processed_f    赋值 。这时候你在保存。就不会出现这个错...
mysql truncated_mysql中出现的Data truncated for column
weixin_35696071的博客
01-19 2569
mysql中想一个数据库中插入一条记录时，有可能因为好多原因，会出现Data truncated for column XXXXX的错误，这是因为你的数据类型的长度不一致导致的，仔细查看一下数据类型的长度，就可以解决这个问题或者这种问题一般mysql5.x上出现。我用的mysql5.2.28，后面查询得知新版本mysql对空值插入有"bug",要在安装mysql的时候去除默认勾选的enable...
Data truncated for column xxx
weixin_33691817的博客
01-11 3787
对于字段XXX，数据发生截断。原因是：字段的取值，不满足约束条件。比如下面的情况： 原来的字段取值为null，现在约束字段not null，就会报错Data truncated for column xxx...
mysql中出现的Data truncated for column
baicp3的专栏
08-12 2万+
1.先描述一下自己出现的问题。 如果你想把允许为空值的勾去掉。。。恰巧数据库中的数据 processed_f 为空没有值。。。。这时候你对数据表结构做更改的时候就会出现Data truncated for column processed_f 的提示。。解决方式即为  给数据库中的字段processed_f    赋值 。这时候你在保存。就不会出现这个错误了。
Data truncation: Out of range value for column `xxx`（MySQL的字段长度和取值范围踩坑）
reading-conference-writing
09-18 6094
测试过的MySQL版本：5.6、8.0。 如果你遇到了Out of range value错误，并且认为数据长度并没有超出字段长度，那么你需要了解一个关键知识点： MySQL中DECIMAL或DOUBLE的长度声明为(字段总长度,浮点位长度) 如DECIMAL(8)表示的是8位的数字，其中浮点位为4位，如1234.1234，而认为整数位是8位则是错误的，如插入值12345678.1234就会...
【异常】MySQL提示异常MysqlDataTruncation: Data truncation: Incorrect datetime value: ‘2023110508‘ for column
本本本添哥
12-02 1151
【代码】【异常】MysqlDataTruncation: Data truncation: Incorrect datetime value: ‘2023110508‘ for column ‘record_
【异常】 日期插入异常提示Data truncation: Incorrect datetime value: ‘2024-03‘ for column ‘record_time‘
本本本添哥
04-01 1122
【代码】【异常】 日期插入异常提示Data truncation: Incorrect datetime value: '2024-03' for column 'record_time'
之前14周的逻辑代码报错2025-07-30 16:57:59.627 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:58:09.628 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:58:19.631 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:58:29.632 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:58:39.633 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:58:49.634 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:58:59.635 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:59:09.636 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:59:29.637 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:59:39.638 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 16:59:59.639 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2025-07-30 17:00:03.250 [0-0-0-writer] WARN CommonRdbmsWriter$Task - 回滚此次写入, 采用每次写入一行方式提交. 因为:Data truncated for column 'WeekNumber' at row 1 2025-07-30 17:00:03.256 [0-0-0-writer] ERROR StdoutPluginCollector - java.sql.SQLException: Data truncated for column 'WeekNumber' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242) ~[mysql-connector-java-5.1.47.jar:5.1.47] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doOneInsert(CommonRdbmsWriter.java:382) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:362) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) [mysqlwriter-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) [datax-core-0.0.1-SNAPSHOT.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_111] 2025-07-30 17:00:03.261 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"超声科","type":"STRING"},{"byteSize":2,"index":6,"rawData":"超声","type":"STRING"},{"byteSize":5,"index":7,"rawData":"B超小器官","type":"STRING"},{"byteSize":3,"index":8,"rawData":463,"type":"LONG"},{"byteSize":3,"index":9,"rawData":"455","type":"DOUBLE"},{"byteSize":3,"index":10,"rawData":"395","type":"DOUBLE"},{"byteSize":2,"index":11,"rawData":"59","type":"DOUBLE"},{"byteSize":3,"index":12,"rawData":"395","type":"DOUBLE"},{"byteSize":2,"index":13,"rawData":"59","type":"DOUBLE"},{"byteSize":2,"index":14,"rawData":"49","type":"DOUBLE"},{"byteSize":2,"index":15,"rawData":"10","type":"DOUBLE"},{"byteSize":2,"index":16,"rawData":"15","type":"DOUBLE"},{"byteSize":3,"index":17,"rawData":"395","type":"DOUBLE"},{"byteSize":3,"index":18,"rawData":"390","type":"DOUBLE"},{"byteSize":6,"index":19,"rawData":"0.3457","type":"DOUBLE"},{"byteSize":6,"index":20,"rawData":"0.6222","type":"DOUBLE"},{"byteSize":6,"index":21,"rawData":"0.3284","type":"DOUBLE"},{"byteSize":6,"index":22,"rawData":"0.8148","type":"DOUBLE"},{"byteSize":6,"index":23,"rawData":"0.9630","type":"DOUBLE"},{"byteSize":6,"index":24,"rawData":"0.9704","type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"2","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"1","type":"DOUBLE"},{"byteSize":3,"index":27,"rawData":"395","type":"DOUBLE"},{"byteSize":6,"index":28,"rawData":"0.8624","type":"DOUBLE"},{"byteSize":3,"index":29,"rawData":"140","type":"DOUBLE"},{"byteSize":3,"index":30,"rawData":"252","type":"DOUBLE"},{"byteSize":3,"index":31,"rawData":"133","type":"DOUBLE"},{"byteSize":3,"index":32,"rawData":"330","type":"DOUBLE"},{"byteSize":3,"index":33,"rawData":"390","type":"DOUBLE"},{"byteSize":3,"index":34,"rawData":"393","type":"DOUBLE"},{"byteSize":3,"index":35,"rawData":"405","type":"DOUBLE"},{"byteSize":3,"index":36,"rawData":"395","type":"DOUBLE"},{"byteSize":3,"index":37,"rawData":"458","type":"DOUBLE"},{"byteSize":6,"index":38,"rawData":"308821","type":"DOUBLE"},{"byteSize":5,"index":39,"rawData":"56949","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.263 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"放射科","type":"STRING"},{"byteSize":2,"index":6,"rawData":"普放","type":"STRING"},{"byteSize":1,"index":7,"rawData":".","type":"STRING"},{"byteSize":3,"index":8,"rawData":734,"type":"LONG"},{"byteSize":3,"index":9,"rawData":"730","type":"DOUBLE"},{"byteSize":1,"index":10,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":11,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":12,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":13,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":14,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":15,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":16,"rawData":"0","type":"DOUBLE"},{"byteSize":3,"index":17,"rawData":"705","type":"DOUBLE"},{"byteSize":3,"index":18,"rawData":"696","type":"DOUBLE"},{"byteSize":0,"index":19,"type":"DOUBLE"},{"byteSize":0,"index":20,"type":"DOUBLE"},{"byteSize":0,"index":21,"type":"DOUBLE"},{"byteSize":0,"index":22,"type":"DOUBLE"},{"byteSize":0,"index":23,"type":"DOUBLE"},{"byteSize":0,"index":24,"type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":27,"rawData":"0","type":"DOUBLE"},{"byteSize":0,"index":28,"type":"DOUBLE"},{"byteSize":3,"index":29,"rawData":"557","type":"DOUBLE"},{"byteSize":3,"index":30,"rawData":"664","type":"DOUBLE"},{"byteSize":3,"index":31,"rawData":"325","type":"DOUBLE"},{"byteSize":3,"index":32,"rawData":"641","type":"DOUBLE"},{"byteSize":3,"index":33,"rawData":"696","type":"DOUBLE"},{"byteSize":1,"index":34,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":35,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":36,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":37,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":38,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":39,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.265 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"放射科","type":"STRING"},{"byteSize":2,"index":6,"rawData":"CT","type":"STRING"},{"byteSize":6,"index":7,"rawData":"CT增强扫描","type":"STRING"},{"byteSize":3,"index":8,"rawData":188,"type":"LONG"},{"byteSize":3,"index":9,"rawData":"168","type":"DOUBLE"},{"byteSize":1,"index":10,"rawData":"0","type":"DOUBLE"},{"byteSize":3,"index":11,"rawData":"168","type":"DOUBLE"},{"byteSize":1,"index":12,"rawData":"0","type":"DOUBLE"},{"byteSize":3,"index":13,"rawData":"168","type":"DOUBLE"},{"byteSize":2,"index":14,"rawData":"74","type":"DOUBLE"},{"byteSize":2,"index":15,"rawData":"94","type":"DOUBLE"},{"byteSize":2,"index":16,"rawData":"22","type":"DOUBLE"},{"byteSize":1,"index":17,"rawData":"7","type":"DOUBLE"},{"byteSize":1,"index":18,"rawData":"7","type":"DOUBLE"},{"byteSize":6,"index":19,"rawData":"0.0000","type":"DOUBLE"},{"byteSize":6,"index":20,"rawData":"0.0532","type":"DOUBLE"},{"byteSize":6,"index":21,"rawData":"0.0426","type":"DOUBLE"},{"byteSize":6,"index":22,"rawData":"0.0745","type":"DOUBLE"},{"byteSize":6,"index":23,"rawData":"0.0745","type":"DOUBLE"},{"byteSize":6,"index":24,"rawData":"1.0000","type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"0","type":"DOUBLE"},{"byteSize":3,"index":27,"rawData":"112","type":"DOUBLE"},{"byteSize":6,"index":28,"rawData":"0.6667","type":"DOUBLE"},{"byteSize":1,"index":29,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":30,"rawData":"5","type":"DOUBLE"},{"byteSize":1,"index":31,"rawData":"4","type":"DOUBLE"},{"byteSize":1,"index":32,"rawData":"7","type":"DOUBLE"},{"byteSize":1,"index":33,"rawData":"7","type":"DOUBLE"},{"byteSize":2,"index":34,"rawData":"94","type":"DOUBLE"},{"byteSize":2,"index":35,"rawData":"94","type":"DOUBLE"},{"byteSize":3,"index":36,"rawData":"112","type":"DOUBLE"},{"byteSize":3,"index":37,"rawData":"168","type":"DOUBLE"},{"byteSize":5,"index":38,"rawData":"18800","type":"DOUBLE"},{"byteSize":1,"index":39,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.267 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"放射科","type":"STRING"},{"byteSize":3,"index":6,"rawData":"MRI","type":"STRING"},{"byteSize":9,"index":7,"rawData":"MR3.0增强扫描","type":"STRING"},{"byteSize":2,"index":8,"rawData":17,"type":"LONG"},{"byteSize":2,"index":9,"rawData":"16","type":"DOUBLE"},{"byteSize":1,"index":10,"rawData":"1","type":"DOUBLE"},{"byteSize":2,"index":11,"rawData":"15","type":"DOUBLE"},{"byteSize":1,"index":12,"rawData":"1","type":"DOUBLE"},{"byteSize":2,"index":13,"rawData":"15","type":"DOUBLE"},{"byteSize":2,"index":14,"rawData":"12","type":"DOUBLE"},{"byteSize":1,"index":15,"rawData":"3","type":"DOUBLE"},{"byteSize":1,"index":16,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":17,"rawData":"1","type":"DOUBLE"},{"byteSize":1,"index":18,"rawData":"1","type":"DOUBLE"},{"byteSize":6,"index":19,"rawData":"0.0000","type":"DOUBLE"},{"byteSize":6,"index":20,"rawData":"0.0000","type":"DOUBLE"},{"byteSize":6,"index":21,"rawData":"0.0000","type":"DOUBLE"},{"byteSize":6,"index":22,"rawData":"0.0000","type":"DOUBLE"},{"byteSize":6,"index":23,"rawData":"0.2500","type":"DOUBLE"},{"byteSize":6,"index":24,"rawData":"0.2500","type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"0","type":"DOUBLE"},{"byteSize":2,"index":27,"rawData":"10","type":"DOUBLE"},{"byteSize":6,"index":28,"rawData":"0.6250","type":"DOUBLE"},{"byteSize":1,"index":29,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":30,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":31,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":32,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":33,"rawData":"1","type":"DOUBLE"},{"byteSize":1,"index":34,"rawData":"1","type":"DOUBLE"},{"byteSize":1,"index":35,"rawData":"4","type":"DOUBLE"},{"byteSize":2,"index":36,"rawData":"10","type":"DOUBLE"},{"byteSize":2,"index":37,"rawData":"16","type":"DOUBLE"},{"byteSize":3,"index":38,"rawData":"425","type":"DOUBLE"},{"byteSize":2,"index":39,"rawData":"68","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.269 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"放射科","type":"STRING"},{"byteSize":2,"index":6,"rawData":"CT","type":"STRING"},{"byteSize":4,"index":7,"rawData":"CT平扫","type":"STRING"},{"byteSize":3,"index":8,"rawData":962,"type":"LONG"},{"byteSize":3,"index":9,"rawData":"949","type":"DOUBLE"},{"byteSize":3,"index":10,"rawData":"862","type":"DOUBLE"},{"byteSize":2,"index":11,"rawData":"89","type":"DOUBLE"},{"byteSize":3,"index":12,"rawData":"847","type":"DOUBLE"},{"byteSize":3,"index":13,"rawData":"104","type":"DOUBLE"},{"byteSize":2,"index":14,"rawData":"96","type":"DOUBLE"},{"byteSize":1,"index":15,"rawData":"8","type":"DOUBLE"},{"byteSize":2,"index":16,"rawData":"35","type":"DOUBLE"},{"byteSize":3,"index":17,"rawData":"858","type":"DOUBLE"},{"byteSize":3,"index":18,"rawData":"818","type":"DOUBLE"},{"byteSize":6,"index":19,"rawData":"0.0807","type":"DOUBLE"},{"byteSize":6,"index":20,"rawData":"0.3848","type":"DOUBLE"},{"byteSize":6,"index":21,"rawData":"0.1579","type":"DOUBLE"},{"byteSize":6,"index":22,"rawData":"0.8351","type":"DOUBLE"},{"byteSize":6,"index":23,"rawData":"0.9567","type":"DOUBLE"},{"byteSize":6,"index":24,"rawData":"0.9591","type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"1","type":"DOUBLE"},{"byteSize":3,"index":27,"rawData":"862","type":"DOUBLE"},{"byteSize":6,"index":28,"rawData":"0.9045","type":"DOUBLE"},{"byteSize":2,"index":29,"rawData":"69","type":"DOUBLE"},{"byteSize":3,"index":30,"rawData":"329","type":"DOUBLE"},{"byteSize":3,"index":31,"rawData":"135","type":"DOUBLE"},{"byteSize":3,"index":32,"rawData":"714","type":"DOUBLE"},{"byteSize":3,"index":33,"rawData":"818","type":"DOUBLE"},{"byteSize":3,"index":34,"rawData":"820","type":"DOUBLE"},{"byteSize":3,"index":35,"rawData":"855","type":"DOUBLE"},{"byteSize":3,"index":36,"rawData":"862","type":"DOUBLE"},{"byteSize":3,"index":37,"rawData":"953","type":"DOUBLE"},{"byteSize":7,"index":38,"rawData":"1206348","type":"DOUBLE"},{"byteSize":6,"index":39,"rawData":"247234","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.271 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"超声科","type":"STRING"},{"byteSize":2,"index":6,"rawData":"超声","type":"STRING"},{"byteSize":4,"index":7,"rawData":"B超空腹","type":"STRING"},{"byteSize":3,"index":8,"rawData":413,"type":"LONG"},{"byteSize":3,"index":9,"rawData":"410","type":"DOUBLE"},{"byteSize":3,"index":10,"rawData":"224","type":"DOUBLE"},{"byteSize":3,"index":11,"rawData":"185","type":"DOUBLE"},{"byteSize":3,"index":12,"rawData":"224","type":"DOUBLE"},{"byteSize":3,"index":13,"rawData":"185","type":"DOUBLE"},{"byteSize":3,"index":14,"rawData":"129","type":"DOUBLE"},{"byteSize":2,"index":15,"rawData":"56","type":"DOUBLE"},{"byteSize":2,"index":16,"rawData":"10","type":"DOUBLE"},{"byteSize":3,"index":17,"rawData":"232","type":"DOUBLE"},{"byteSize":3,"index":18,"rawData":"232","type":"DOUBLE"},{"byteSize":6,"index":19,"rawData":"0.2393","type":"DOUBLE"},{"byteSize":6,"index":20,"rawData":"0.7179","type":"DOUBLE"},{"byteSize":6,"index":21,"rawData":"0.5750","type":"DOUBLE"},{"byteSize":6,"index":22,"rawData":"0.8286","type":"DOUBLE"},{"byteSize":6,"index":23,"rawData":"0.8286","type":"DOUBLE"},{"byteSize":6,"index":24,"rawData":"0.9857","type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"2","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"3","type":"DOUBLE"},{"byteSize":3,"index":27,"rawData":"370","type":"DOUBLE"},{"byteSize":6,"index":28,"rawData":"0.9024","type":"DOUBLE"},{"byteSize":2,"index":29,"rawData":"67","type":"DOUBLE"},{"byteSize":3,"index":30,"rawData":"201","type":"DOUBLE"},{"byteSize":3,"index":31,"rawData":"161","type":"DOUBLE"},{"byteSize":3,"index":32,"rawData":"232","type":"DOUBLE"},{"byteSize":3,"index":33,"rawData":"232","type":"DOUBLE"},{"byteSize":3,"index":34,"rawData":"276","type":"DOUBLE"},{"byteSize":3,"index":35,"rawData":"280","type":"DOUBLE"},{"byteSize":3,"index":36,"rawData":"370","type":"DOUBLE"},{"byteSize":3,"index":37,"rawData":"410","type":"DOUBLE"},{"byteSize":6,"index":38,"rawData":"273819","type":"DOUBLE"},{"byteSize":5,"index":39,"rawData":"68145","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.272 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"特检科","type":"STRING"},{"byteSize":3,"index":6,"rawData":"肌电图","type":"STRING"},{"byteSize":5,"index":7,"rawData":"肌电图检查","type":"STRING"},{"byteSize":2,"index":8,"rawData":31,"type":"LONG"},{"byteSize":2,"index":9,"rawData":"31","type":"DOUBLE"},{"byteSize":2,"index":10,"rawData":"30","type":"DOUBLE"},{"byteSize":1,"index":11,"rawData":"1","type":"DOUBLE"},{"byteSize":2,"index":12,"rawData":"30","type":"DOUBLE"},{"byteSize":1,"index":13,"rawData":"1","type":"DOUBLE"},{"byteSize":1,"index":14,"rawData":"1","type":"DOUBLE"},{"byteSize":1,"index":15,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":16,"rawData":"1","type":"DOUBLE"},{"byteSize":2,"index":17,"rawData":"30","type":"DOUBLE"},{"byteSize":2,"index":18,"rawData":"30","type":"DOUBLE"},{"byteSize":6,"index":19,"rawData":"0.6000","type":"DOUBLE"},{"byteSize":6,"index":20,"rawData":"0.7333","type":"DOUBLE"},{"byteSize":6,"index":21,"rawData":"0.5333","type":"DOUBLE"},{"byteSize":6,"index":22,"rawData":"0.9667","type":"DOUBLE"},{"byteSize":6,"index":23,"rawData":"1.0000","type":"DOUBLE"},{"byteSize":6,"index":24,"rawData":"1.0000","type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"0","type":"DOUBLE"},{"byteSize":2,"index":27,"rawData":"18","type":"DOUBLE"},{"byteSize":6,"index":28,"rawData":"0.5806","type":"DOUBLE"},{"byteSize":2,"index":29,"rawData":"18","type":"DOUBLE"},{"byteSize":2,"index":30,"rawData":"22","type":"DOUBLE"},{"byteSize":2,"index":31,"rawData":"16","type":"DOUBLE"},{"byteSize":2,"index":32,"rawData":"29","type":"DOUBLE"},{"byteSize":2,"index":33,"rawData":"30","type":"DOUBLE"},{"byteSize":2,"index":34,"rawData":"30","type":"DOUBLE"},{"byteSize":2,"index":35,"rawData":"30","type":"DOUBLE"},{"byteSize":2,"index":36,"rawData":"18","type":"DOUBLE"},{"byteSize":2,"index":37,"rawData":"31","type":"DOUBLE"},{"byteSize":4,"index":38,"rawData":"2604","type":"DOUBLE"},{"byteSize":4,"index":39,"rawData":"1829","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.274 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"特检科","type":"STRING"},{"byteSize":3,"index":6,"rawData":"肺功能","type":"STRING"},{"byteSize":1,"index":7,"rawData":".","type":"STRING"},{"byteSize":2,"index":8,"rawData":51,"type":"LONG"},{"byteSize":2,"index":9,"rawData":"50","type":"DOUBLE"},{"byteSize":1,"index":10,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":11,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":12,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":13,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":14,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":15,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":16,"rawData":"0","type":"DOUBLE"},{"byteSize":2,"index":17,"rawData":"25","type":"DOUBLE"},{"byteSize":2,"index":18,"rawData":"25","type":"DOUBLE"},{"byteSize":0,"index":19,"type":"DOUBLE"},{"byteSize":0,"index":20,"type":"DOUBLE"},{"byteSize":0,"index":21,"type":"DOUBLE"},{"byteSize":0,"index":22,"type":"DOUBLE"},{"byteSize":0,"index":23,"type":"DOUBLE"},{"byteSize":0,"index":24,"type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":27,"rawData":"0","type":"DOUBLE"},{"byteSize":0,"index":28,"type":"DOUBLE"},{"byteSize":2,"index":29,"rawData":"15","type":"DOUBLE"},{"byteSize":2,"index":30,"rawData":"25","type":"DOUBLE"},{"byteSize":2,"index":31,"rawData":"19","type":"DOUBLE"},{"byteSize":2,"index":32,"rawData":"25","type":"DOUBLE"},{"byteSize":2,"index":33,"rawData":"25","type":"DOUBLE"},{"byteSize":1,"index":34,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":35,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":36,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":37,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":38,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":39,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:03.276 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据: {"exception":"Data truncated for column 'WeekNumber' at row 1","record":[{"byteSize":0,"index":0,"type":"STRING"},{"byteSize":8,"index":1,"rawData":1745164800000,"type":"DATE"},{"byteSize":6,"index":2,"rawData":202516,"type":"LONG"},{"byteSize":2,"index":3,"rawData":"01","type":"STRING"},{"byteSize":2,"index":4,"rawData":"检查","type":"STRING"},{"byteSize":3,"index":5,"rawData":"超声科","type":"STRING"},{"byteSize":2,"index":6,"rawData":"超声","type":"STRING"},{"byteSize":6,"index":7,"rawData":"B超妇科三维","type":"STRING"},{"byteSize":3,"index":8,"rawData":121,"type":"LONG"},{"byteSize":3,"index":9,"rawData":"113","type":"DOUBLE"},{"byteSize":3,"index":10,"rawData":"103","type":"DOUBLE"},{"byteSize":2,"index":11,"rawData":"12","type":"DOUBLE"},{"byteSize":3,"index":12,"rawData":"103","type":"DOUBLE"},{"byteSize":2,"index":13,"rawData":"12","type":"DOUBLE"},{"byteSize":1,"index":14,"rawData":"7","type":"DOUBLE"},{"byteSize":1,"index":15,"rawData":"5","type":"DOUBLE"},{"byteSize":1,"index":16,"rawData":"0","type":"DOUBLE"},{"byteSize":3,"index":17,"rawData":"105","type":"DOUBLE"},{"byteSize":3,"index":18,"rawData":"104","type":"DOUBLE"},{"byteSize":6,"index":19,"rawData":"0.6389","type":"DOUBLE"},{"byteSize":6,"index":20,"rawData":"0.8889","type":"DOUBLE"},{"byteSize":6,"index":21,"rawData":"0.4907","type":"DOUBLE"},{"byteSize":6,"index":22,"rawData":"0.9167","type":"DOUBLE"},{"byteSize":6,"index":23,"rawData":"0.9630","type":"DOUBLE"},{"byteSize":6,"index":24,"rawData":"0.9722","type":"DOUBLE"},{"byteSize":1,"index":25,"rawData":"0","type":"DOUBLE"},{"byteSize":1,"index":26,"rawData":"6","type":"DOUBLE"},{"byteSize":2,"index":27,"rawData":"95","type":"DOUBLE"},{"byteSize":6,"index":28,"rawData":"0.8120","type":"DOUBLE"},{"byteSize":2,"index":29,"rawData":"69","type":"DOUBLE"},{"byteSize":2,"index":30,"rawData":"96","type":"DOUBLE"},{"byteSize":2,"index":31,"rawData":"53","type":"DOUBLE"},{"byteSize":2,"index":32,"rawData":"99","type":"DOUBLE"},{"byteSize":3,"index":33,"rawData":"104","type":"DOUBLE"},{"byteSize":3,"index":34,"rawData":"105","type":"DOUBLE"},{"byteSize":3,"index":35,"rawData":"108","type":"DOUBLE"},{"byteSize":2,"index":36,"rawData":"95","type":"DOUBLE"},{"byteSize":3,"index":37,"rawData":"117","type":"DOUBLE"},{"byteSize":5,"index":38,"rawData":"27830","type":"DOUBLE"},{"byteSize":5,"index":39,"rawData":"10648","type":"DOUBLE"},{"byteSize":1,"index":40,"rawData":"0","type":"DOUBLE"}],"type":"writer"} 2025-07-30 17:00:05.209 [0-0-0-writer] WARN CommonRdbmsWriter$Task - 回滚此次写入, 采用每次写入一行方式提交. 因为:Data truncated for column 'WeekNumber' at row 1 2025-07-30 17:00:09.640 [job-0] INFO StandAloneJobContainerCommunicator - Total 2102 records, 205261 bytes | Speed 20.04KB/s, 210 records/s | Error 2102 records, 205261 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 133.374s | Percentage 100.00% 2025-07-30 17:00:09.641 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错. 2025-07-30 17:00:09.641 [job-0] ERROR JobContainer - Exception when job run com.alibaba.datax.common.exception.DataXException: Code:[Framework-14], Description:[DataX传输脏数据超过用户预期，该错误通常是由于源端数据存在较多业务脏数据导致，请仔细检查DataX汇报的脏数据日志信息, 或者您可以适当调大脏数据阈值 .]. - 脏数据条数检查不通过，限制是[0]条，但实际上捕获了[2102]条. at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.util.ErrorRecordChecker.checkRecordLimit(ErrorRecordChecker.java:58) ~[datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.job.scheduler.AbstractScheduler.schedule(AbstractScheduler.java:89) ~[datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.job.JobContainer.schedule(JobContainer.java:535) ~[datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:119) ~[datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.Engine.start(Engine.java:92) [datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.Engine.entry(Engine.java:171) [datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.Engine.main(Engine.java:204) [datax-core-0.0.1-SNAPSHOT.jar:na] 2025-07-30 17:00:09.642 [job-0] INFO StandAloneJobContainerCommunicator - Total 2102 records, 205261 bytes | Speed 200.45KB/s, 2102 records/s | Error 2102 records, 205261 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 133.374s | Percentage 100.00% 2025-07-30 17:00:09.643 [job-0] ERROR Engine - 经DataX智能分析,该任务最可能的错误原因是: com.alibaba.datax.common.exception.DataXException: Code:[Framework-14], Description:[DataX传输脏数据超过用户预期，该错误通常是由于源端数据存在较多业务脏数据导致，请仔细检查DataX汇报的脏数据日志信息, 或者您可以适当调大脏数据阈值 .]. - 脏数据条数检查不通过，限制是[0]条，但实际上捕获了[2102]条. at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) at com.alibaba.datax.core.util.ErrorRecordChecker.checkRecordLimit(ErrorRecordChecker.java:58) at com.alibaba.datax.core.job.scheduler.AbstractScheduler.schedule(AbstractScheduler.java:89) at com.alibaba.datax.core.job.JobContainer.schedule(JobContainer.java:535) at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:119) at com.alibaba.datax.core.Engine.start(Engine.java:92) at com.alibaba.datax.core.Engine.entry(Engine.java:171) at com.alibaba.datax.core.Engine.main(Engine.java:204)
最新发布
07-31
1. 如何处理类似错误：Data truncated for column 'xxx' at row 1？ 2. char和varchar类型在MySQL中有什么主要区别？如何选择？ 3. 如果WeekNumber需要参与数学运算，应该选择什么数据类型？ 4. 如何验证修改后的表...
MySQL报错：Data truncated for column
YongDaiMe的博客
04-09 3万+
关于MySQL报错：Data truncated for column，我认为主要有两个原因： 表字段长度已经调整到足够长度； 在修改主键时，如果表中有数据或者设置主键的那一列数据为NULL，也会报同样的错误。 我想将stu_id的值设为主键，但是此时表中有数据（且为NULL）： 此时会报错： 解决的办法有两种：第一种是删除表中所有数据后在添加主键；第二种是将向stu_id中添加值，不让其...
mysql中出现的Data truncated for column（表字段长度已经调整到足够长度）
热门推荐
yphust的博客
07-11 15万+
问题描述：更新表A的某个varchar(10)的字段时报错：Data truncated for column，根据百度查询的结果看是更新字段长度超过列的长度。然后调整了该字段的长度，增大到varchar(50)（现在待更新的字段长度介于10-50之间，也就是肯定没有超长的），结果仍然报相同的错误。解决方案：问题有点奇怪，根据错误提示 ，问题原因很明确，但是为什么还是继续报一样的错误呢？无意中点到...
mysql 中Data truncated for column ‘XXX‘
Ciel_Y的博客
04-11 476
我的sql是往一个表中插入数据，但是查询出的数据是Varchar类型的 200。这张表中它的数据类型是varchar(32)不足以存放数据，所以增加长度就可以了。而接收它的表是Varchar(2)
Data truncated for column ‘xxx‘ at row 1
weixin_43646021的博客
04-29 702
Data truncated for column 'xxx' at row 1 的bug 解决方式
MySQL报错:Data truncated for column 的原因之一
tudoujiding的专栏
12-01 1万+
MySQL报错:Data truncated for column 解决途径之一！
java.sql.SQLException: Data truncated for column ‘xxx‘ at row 1 Query: insert into user values
热爱技术，热爱生活！
12-27 873
错误： java.sql.SQLException: Data truncated for column 'xxx' at row 1 Query: insert into user values 错误原因： xxx字段的数据类型或长度与插入的不一致引起，所以要么改数据库该字段的数据格式，要么改插入的数据。 ...
【MySQL报错】---Data truncated for column ‘age‘ at row...
2302_81090306的博客
10-02 1367
Data truncated for column ‘字段名‘ at row ...的原因及解决方法.
Data truncation: Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column xxx
WhileTrue
01-07 6111
一、保存原因 出现这个报错的问题是，当数据库的表中已经有数据的时候，再添加一个datetime类型的字段，并且设置为不允许为null，就会出现此异常。经测试，其他类型的字段没有出现此问题，只发现datetime类型字段会出现。 二、解决方法。 1、修改数据库配置，设置sql_mode set @@global.sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE...
Data truncated for column MYSQL修改表报错
lq545209147的博客
01-13 1607
报错内容 修改enum(枚举)类型字段的选项时报错 #ddl `col_name` enum('3','2','1') NOT NULL COLLATE utf8mb4_bin DEFAULT '1' #报错类容如下 Data truncated for column 'col_name' at row 1 经过排查,并非字面意思,数据库列长度也是足够的.该字段类型是 enum (枚举) 问题分析 /* 由于该字段以前的值是 'a','b','c' 而且是非空的 那么现在要删除原有 'a','b',
data truncated for column xxx
08-31
您好！对于您提到的问题，出现 "data truncated for column xxx" 的情况通常是由于插入或更新数据库时，所提供的数据超出了目标列的最大长度或格式不匹配导致的。 要解决这个问题，您可以采取以下几个步骤： 1. 检查目标列的最大长度：确认您要插入或更新的数据是否超过了目标列的最大字符数限制。如果是，请调整数据截断或扩大目标列的长度。 2. 检查数据类型匹配：确保插入或更新的数据类型与目标列的数据类型相匹配。例如，如果目标列是整数类型，但提供的数据是字符串，将会触发截断错误。请确保提供的数据类型与目标列的数据类型一致。 3. 调整数据格式：如果您的数据包含特殊字符或格式不符合目标列的要求，可能会触发截断错误。请检查并调整数据格式，以确保与目标列的要求一致。 4. 数据验证：在插入或更新数据之前，进行数据验证以确保其符合目标列的规范。可以使用正则表达式或其他方法对数据进行验证，避免出现截断错误。 请注意，在解决此问题时，请仔细检查相关数据库表和列的定义，并确保提供的数据与其规范相匹配。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值