报错：Data truncated for column 'parent_id' at row1

最新推荐文章于 2025-07-11 09:32:13 发布

最新推荐文章于 2025-07-11 09:32:13 发布 · 432 阅读

本文探讨了在执行SQL脚本过程中遇到的“Datatruncatedforcolumn'parent_id'atrow1”错误的原因及解决办法。主要原因是由于插入的数据类型与表中定义的字段类型不符造成的，例如将字符串类型的数据插入到整型字段中。

如果在运行系统.sql脚本文件时报：Data truncated for column 'parent_id' at row1 错误。

主要原因是在建表的列为特定类型，而所插入的数据类型没与其字段一一对应。

比如本来建表中字段一个int类型的，而你在insert表时有个字段写成了string类型，则就报此错误了。

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

iteye_14721

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

YOLOv2训练自己的数据集（识别海参）

xiao__run的博客

12-04

1万+

检测或者训练有问题的可发邮件咨询小编，小编尽力解答1039463596@qq.com 好吧，正式开始跑程序（其实官网都有）这篇文章是训练YOLO v2过程中的经验总结，我使用YOLO v2训练一组自己的数据，训练后的model，在阈值为.25的情况下，Recall值是95.54%，Precision 是97.27%。需要注意的是，这一训练过程可能只对我自己的训练集有效，因为我是根据我这一训

修改或更新数据库，提示Data truncated for column ‘字段名‘ at row 1 的原因及解决方法

qq_43070236的博客

08-06

11万+

修改或更新数据库，提示Data truncated for column ‘字段名‘ at row 1 的原因及解决方法

参与评论您还未登录，请先登录后发表或查看评论

mysql插入数据出现Data truncated异常解决办法

lvweizhu的专栏

06-11

1万+

在使用sqlsugar批量插入数据时，出现了‘Data truncated for column 'value' at row 89‘这个错误，经过分析发现，原来是这个字段长度太设置的太短了，我设置的varchar（20），但是数据的实际长度超过该长度，如图：我改为varchar(30),成功解决问题。 ...

Java在MySQL数据报错Data truncation: Data too long for column ‘**‘ at row 1 处理

qq_33789001的博客

04-18

9594

在Java SpringBoot MyBatis 框架的项目中，一切正常，不过在一个接口的参数字段传入过大的数据就会报此错误：请求常:org.springframework.dao.DataIntegrityViolationException:此错误的直白翻译就是数据对于数据库的字段来说过长。

/**************************************************************************** ** ** Copyright (C) 2021 The Qt Company Ltd. ** Contact: https://www.qt.io/licensing/ ** ** This file is part of the Qt Quick Dialogs module of the Qt Toolkit. ** ** $QT_BEGIN_LICENSE:COMM$ ** ** Commercial License Usage ** Licensees holding valid commercial Qt licenses may use this file in ** accordance with the commercial license agreement provided with the ** Software or, alternatively, in accordance with the terms contained in ** a written agreement between you and The Qt Company. For licensing terms ** and conditions see https://www.qt.io/terms-conditions. For further ** information use the contact form at https://www.qt.io/contact-us. ** ** $QT_END_LICENSE$ ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ****************************************************************************/ import QtQml 2.14 as Qml import QtQuick 2.2 import QtQuick.Controls 1.2 import QtQuick.Controls.Private 1.0 as ControlsPrivate import QtQuick.Dialogs 1.1 import QtQuick.Dialogs.Private 1.1 import QtQuick.Layouts 1.1 import QtQuick.Window 2.1 import Qt.labs.folderlistmodel 2.1 import Qt.labs.settings 1.0 import "qml" AbstractFileDialog { id: root property Component modelComponent: Component { FolderListModel { showFiles: !root.selectFolder nameFilters: root.selectedNameFilterExtensions sortField: (view.sortIndicatorColumn === 0 ? FolderListModel.Name : (view.sortIndicatorColumn === 1 ? FolderListModel.Type : (view.sortIndicatorColumn === 2 ? FolderListModel.Size : FolderListModel.LastModified))) sortReversed: view.sortIndicatorOrder === Qt.DescendingOrder } } onVisibleChanged: { if (visible) { // If the TableView doesn't have a model yet, create it asynchronously to avoid a UI freeze if (!view.model) { var incubator = modelComponent.incubateObject(null, { }) function init(model) { view.model = model model.nameFilters = root.selectedNameFilterExtensions root.folder = model.folder } if (incubator.status === Component.Ready) { init(incubator.object) } else { incubator.onStatusChanged = function(status) { if (status === Component.Ready) init(incubator.object) } } } view.needsWidthAdjustment = true view.selection.clear() view.focus = true } } Component.onCompleted: { filterField.currentIndex = root.selectedNameFilterIndex root.favoriteFolders = settings.favoriteFolders } Component.onDestruction: { settings.favoriteFolders = root.favoriteFolders } property Settings settings: Settings { category: "QQControlsFileDialog" property alias width: root.width property alias height: root.height property alias sidebarWidth: sidebar.width property alias sidebarSplit: shortcutsScroll.height property alias sidebarVisible: root.sidebarVisible property variant favoriteFolders: [] } property bool showFocusHighlight: false property SystemPalette palette: SystemPalette { } property var favoriteFolders: [] function dirDown(path) { view.selection.clear() root.folder = root.pathToUrl(path) } function dirUp() { view.selection.clear() if (view.model.parentFolder != "") root.folder = view.model.parentFolder } function acceptSelection() { // transfer the view's selections to QQuickFileDialog clearSelection() if (selectFolder && view.selection.count === 0) addSelection(folder) else { view.selection.forEach(function(idx) { if (view.model.isFolder(idx)) { if (selectFolder) addSelection(view.model.get(idx, "fileURL")) } else { if (!selectFolder) addSelection(view.model.get(idx, "fileURL")) } }) } accept() } property Action dirUpAction: Action { text: "\ue810" shortcut: "Ctrl+U" onTriggered: dirUp() tooltip: qsTr("Go up to the folder containing this one") } Rectangle { id: window implicitWidth: Math.min(root.__maximumDimension, Math.max(Screen.pixelDensity * 100, splitter.implicitWidth)) implicitHeight: Math.min(root.__maximumDimension, Screen.pixelDensity * 80) color: root.palette.window Qml.Binding { target: view.model property: "folder" value: root.folder restoreMode: Binding.RestoreBinding } Qml.Binding { target: currentPathField property: "text" value: root.urlToPath(root.folder) restoreMode: Binding.RestoreBinding } Keys.onPressed: { event.accepted = true switch (event.key) { case Qt.Key_Back: case Qt.Key_Escape: reject() break default: event.accepted = false break } } Keys.forwardTo: [view.flickableItem] SplitView { id: splitter x: 0 width: parent.width anchors.top: titleBar.bottom anchors.bottom: bottomBar.top Column { id: sidebar Component.onCompleted: if (width < 1) width = sidebarSplitter.maxShortcutWidth height: parent.height width: 0 // initial width only; settings and onCompleted will override it visible: root.sidebarVisible SplitView { id: sidebarSplitter orientation: Qt.Vertical property real rowHeight: 10 property real maxShortcutWidth: 80 width: parent.width height: parent.height - favoritesButtons.height ScrollView { id: shortcutsScroll Component.onCompleted: { if (height < 1) height = sidebarSplitter.rowHeight * 4.65 Layout.minimumHeight = sidebarSplitter.rowHeight * 2.65 } height: 0 // initial width only; settings and onCompleted will override it ListView { id: shortcutsView model: __shortcuts.length anchors.bottomMargin: ControlsPrivate.Settings.hasTouchScreen ? Screen.pixelDensity * 3.5 : anchors.margins implicitHeight: model.count * sidebarSplitter.rowHeight delegate: Item { id: shortcutItem width: sidebarSplitter.width height: shortcutLabel.implicitHeight * 1.5 Text { id: shortcutLabel text: __shortcuts[index].name anchors { verticalCenter: parent.verticalCenter left: parent.left right: parent.right margins: 4 } elide: Text.ElideLeft renderType: ControlsPrivate.Settings.isMobile ? Text.QtRendering : Text.NativeRendering Component.onCompleted: { sidebarSplitter.rowHeight = parent.height if (implicitWidth * 1.2 > sidebarSplitter.maxShortcutWidth) sidebarSplitter.maxShortcutWidth = implicitWidth * 1.2 } } MouseArea { anchors.fill: parent onClicked: root.folder = __shortcuts[index].url } } } } ScrollView { Layout.minimumHeight: sidebarSplitter.rowHeight * 2.5 ListView { id: favorites model: root.favoriteFolders anchors.topMargin: ControlsPrivate.Settings.hasTouchScreen ? Screen.pixelDensity * 3.5 : anchors.margins delegate: Item { width: favorites.width height: folderLabel.implicitHeight * 1.5 Text { id: folderLabel text: root.favoriteFolders[index] anchors { verticalCenter: parent.verticalCenter left: parent.left right: parent.right margins: 4 } elide: Text.ElideLeft renderType: ControlsPrivate.Settings.isMobile ? Text.QtRendering : Text.NativeRendering } Menu { id: favoriteCtxMenu title: root.favoriteFolders[index] MenuItem { text: qsTr("Remove favorite") onTriggered: { root.favoriteFolders.splice(index, 1) favorites.model = root.favoriteFolders } } } MouseArea { id: favoriteArea anchors.fill: parent acceptedButtons: Qt.LeftButton | Qt.RightButton hoverEnabled: true onClicked: { if (mouse.button == Qt.LeftButton) root.folder = root.favoriteFolders[index] else if (mouse.button == Qt.RightButton) favoriteCtxMenu.popup() } onExited: ControlsPrivate.Tooltip.hideText() onCanceled: ControlsPrivate.Tooltip.hideText() Timer { interval: 1000 running: favoriteArea.containsMouse && !favoriteArea.pressed && folderLabel.truncated onTriggered: ControlsPrivate.Tooltip.showText(favoriteArea, Qt.point(favoriteArea.mouseX, favoriteArea.mouseY), urlToPath(root.favoriteFolders[index])) } } } } } } Row { id: favoritesButtons height: plusButton.height + 1 anchors.right: parent.right anchors.rightMargin: 6 layoutDirection: Qt.RightToLeft Button { id: plusButton style: IconButtonStyle { } text: "\ue83e" tooltip: qsTr("Add the current directory as a favorite") width: height onClicked: { root.favoriteFolders.push(root.folder) favorites.model = root.favoriteFolders } } } } TableView { id: view sortIndicatorVisible: true Layout.fillWidth: true Layout.minimumWidth: 40 property bool needsWidthAdjustment: true selectionMode: root.selectMultiple ? (ControlsPrivate.Settings.hasTouchScreen ? SelectionMode.MultiSelection : SelectionMode.ExtendedSelection) : SelectionMode.SingleSelection onRowCountChanged: if (needsWidthAdjustment && rowCount > 0) { resizeColumnsToContents() needsWidthAdjustment = false } model: null onActivated: if (view.focus) { if (view.selection.count > 0 && view.model.isFolder(row)) { dirDown(view.model.get(row, "filePath")) } else { root.acceptSelection() } } onClicked: currentPathField.text = view.model.get(row, "filePath") TableViewColumn { id: fileNameColumn role: "fileName" title: qsTr("Filename") delegate: Item { implicitWidth: pathText.implicitWidth + pathText.anchors.leftMargin + pathText.anchors.rightMargin IconGlyph { id: fileIcon x: 4 height: parent.height - 2 unicode: view.model.isFolder(styleData.row) ? "\ue804" : "\ue802" } Text { id: pathText text: styleData.value anchors { left: parent.left right: parent.right leftMargin: fileIcon.width + 6 rightMargin: 4 verticalCenter: parent.verticalCenter } color: styleData.textColor elide: Text.ElideRight renderType: ControlsPrivate.Settings.isMobile ? Text.QtRendering : Text.NativeRendering } } } TableViewColumn { role: "fileSuffix" title: qsTr("Type", "file type (extension)") // TODO should not need to create a whole new component just to customize the text value // something like textFormat: function(text) { return view.model.get(styleData.row, "fileIsDir") ? "folder" : text } delegate: Item { implicitWidth: sizeText.implicitWidth + sizeText.anchors.leftMargin + sizeText.anchors.rightMargin Text { id: sizeText text: view.model.get(styleData.row, "fileIsDir") ? "folder" : styleData.value anchors { left: parent.left right: parent.right leftMargin: 4 rightMargin: 4 verticalCenter: parent.verticalCenter } color: styleData.textColor elide: Text.ElideRight renderType: ControlsPrivate.Settings.isMobile ? Text.QtRendering : Text.NativeRendering } } } TableViewColumn { role: "fileSize" title: qsTr("Size", "file size") horizontalAlignment: Text.AlignRight } TableViewColumn { id: modifiedColumn; role: "fileModified" ; title: qsTr("Modified", "last-modified time") } TableViewColumn { id: accessedColumn; role: "fileAccessed" ; title: qsTr("Accessed", "last-accessed time") } } } ToolBar { id: titleBar RowLayout { anchors.fill: parent ToolButton { action: dirUpAction style: IconButtonStyle { } Layout.maximumWidth: height * 1.5 } TextField { id: currentPathField Layout.fillWidth: true function doAccept() { root.clearSelection() if (root.addSelection(root.pathToUrl(text))) root.accept() else root.folder = root.pathFolder(text) } onAccepted: doAccept() } } } Item { id: bottomBar width: parent.width height: buttonRow.height + buttonRow.spacing * 2 anchors.bottom: parent.bottom Row { id: buttonRow anchors.right: parent.right anchors.rightMargin: spacing anchors.verticalCenter: parent.verticalCenter spacing: 4 Button { id: toggleSidebarButton checkable: true style: IconButtonStyle { } text: "\u25E7" height: cancelButton.height width: height checked: root.sidebarVisible onClicked: { root.sidebarVisible = !root.sidebarVisible } } ComboBox { id: filterField model: root.nameFilters visible: !selectFolder width: bottomBar.width - toggleSidebarButton.width - cancelButton.width - okButton.width - parent.spacing * 6 anchors.verticalCenter: parent.verticalCenter onCurrentTextChanged: { root.selectNameFilter(currentText) if (view.model) view.model.nameFilters = root.selectedNameFilterExtensions } } Button { id: cancelButton text: qsTr("Cancel") onClicked: root.reject() } Button { id: okButton text: root.selectFolder ? qsTr("Choose") : (selectExisting ? qsTr("Open") : qsTr("Save")) onClicked: { if (view.model.isFolder(view.currentRow) && !selectFolder) dirDown(view.model.get(view.currentRow, "filePath")) else if (!(root.selectExisting)) currentPathField.doAccept() else root.acceptSelection() } } } } } }

最新发布

11-05

Qt Quick是Qt框架的一部分，利用QML语言和JavaScript实现高效UI开发，适用于高性能和复杂交互的跨平台应用开发 [^1][^3]。基于Qt Quick的文件对话框的主要功能是允许用户选择文件或文件夹。它可以提供文件浏览、过滤...

ORA-39181 导出的时候数据库是要处于open状态，数据库处于close、nomount、mount都无法导出的

weixin_tank88921的博客

07-27

1467

错误的原因是一个没有权限的用户试图导出一个具有细粒度访问控制的表。该表的拥有者访问该表会受限，因此不能导出该表里的所有行。该表的所有者只能导出其能看到的那些表行。因此，要保证表的完整性，在安全策略的前提下导入该表时，导入该表的用户必须拥有足够的权限来重建该表。导出的时候数据库是要处于open状态，数据库处于close、nomount、mount都无法导出的。源：12.2.0.1目标：11.2.0.4。处理：考虑改用exp/imp方式。考虑尝试：只导元数据正常。

微服务seata 1.4.2 分布式事务AT模式示例

liaomingwu的专栏

03-25

1804

seata 1.4.2 分布式事务AT模式示例

Apache Iceberg Research

yisuoyanyv的博客

06-01

1334

Apache iceberg 的感性认知，架构，业务，特性，优点

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 的原因之一

tudoujiding的专栏

12-01

1万+

MySQL报错:Data truncated for column 解决途径之一！

Data truncated for column 'uuid' at row 1报错可能原因

qq_42180956的博客

12-31

4772

解决方法如下：一、检查是否乱码。更改统一的字符类型，比如更改字符类型为utf8；二、如果是 Enum，则可能是添加的字符不在enum类型范围内；三、可能是在alter table更改列设置时，影响原来存入的值，这时可将原值update为需要的类型值或删除这些原值再alter table。四、检查是不是数据类型的长度不一致导致的。这个比较麻烦具体步骤如下： 1、程序中检查日期的范围，当超出时...

数据库提示：Data truncated for column ‘字段名‘ at row 1

weixin_49114503的博客

07-11

1400

数据库提示：Data truncated for column ‘字段名‘ at row 1

【MySQL报错】---Data truncated for column ‘age‘ at row...

2302_81090306的博客

10-02

1539

Data truncated for column ‘字段名‘ at row ...的原因及解决方法.

springboot项目出现Data truncated for column ‘id‘ at row 1报错的解决办法

大户影视的博客

02-13

1926

如果需要更大的数值范围，考虑修改表的结构。例如，将id列的数据类型从INT改为BIGINT。

TiDB：ERROR 1265 : Data Truncated 解决

Penrosee的博客

03-06

2429

如果你也遇到这样的报错，试试下面的方法是否能解决你的问题。 TiBD 报Data Truncated 错，也没有列出具体阶段的字段，检查下字段长度是否超出表设计，如果都在长度允许的范围内，插入依然报错，那就试试下面的方法吧。 select @@version 这是我的数据库版本：5.7.25-TiDB-v3.0.9 步骤如下： 1、查看数据库的sql mode，记录下来，以便最后恢复...

Data truncated for column MYSQL修改表报错

lq545209147的博客

01-13

1636

报错内容修改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',

mysql中出现的Data truncated for column（表字段长度已经调整到足够长度）