java.sql.SQLException: Data truncated for column 'myprice' at row 1

来源：互联网发布：碟中谍4 知乎编辑：程序博客网时间：2024/06/09 22:01

1.今天通过java web连接mysql数据库并且录入信息到数据库的时候，出现了java.sql.SQLException: Data truncated for column 'myprice' at row 1

自己的解决办法：

a.首先查看写的代码是否存在问题

1)每个input的id是否正确

2)提交按钮button是否写对，查看onclick调用的方法是否正确

3)form表单id是否写了，是否提交了

b.数据库版本的问题

1)是否兼容

2)查看数据库表的设计是否正确，考虑精度的问题

阅读全文

1 0

java.sql.SQLException: Data truncated for column 'myprice' at row 1
java.sql.SQLException: Data truncated for column 'uid' at row 1
Cause: java.sql.SQLException: Data truncated for column 'LOAN_SUM' at row 1
nested exception is java.sql.SQLException: Data truncated for column 'PassWord' at row 72
java.sql.BatchUpdateException: Data truncated for column 'nowCost' at row 1
Data truncation: Data truncated for column 'content' at row 1
Data truncation: Data truncated for column 'xxxxxxxxx' at row 1
Data truncated for column at row
load data 报错" truncated for column..... at row 1"
Warning(1265)Data truncated for column 'v_mmi' at row 1
Data truncated for column 'id' at row 1
Warning: Data truncated for column at row 1
BatchUpdateException: Data truncated for column 'id' at row 1
报错Java.sql.SQLException: Data truncation: Data too long for column 'content' at row 1 Query
java.sql.SQLException: Incorrect integer value: '' for column 'id' at row 1
java.sql.SQLException: Incorrect integer value: '' for column 'id' at row 1
java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8E' for column 'nick' at row 1
java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\xB3' for column 'Content' at row 1
射频频段
String格式转换成Data格式
Linux环境下获取硬盘序列号、型号
java中volatile关键字的含义
第1章欢迎进入Node.js世界
java.sql.SQLException: Data truncated for column 'myprice' at row 1
ssh整合是出现异常： getFlushMode is not valid without active transaction
Linux，Window之间文件传输-NFS，Samba，SSH
美团CODEM 初赛B 景区路线规划概率DP
POJ 3468 线段树解题报告
CentOS7上 pip install MySQL-python 安装失败（error: command 'gcc' failed with exit status 1）的解决办法
苹果捕捉
谱聚类算法(Spectral Clustering)
HDU 1203