com.mysql.jdbc.MysqlDataTruncation 报错_caused by: com.mysql.jdbc.mysqldatatruncation: dat-优快云博客

在使用JDBC操作MySQL时遇到com.mysql.jdbc.MysqlDataTruncation错误，原因是插入的日期值'1988-09-03'不符合列格式。错误源于SQL语句的格式问题，当在输入语句中使用换行符时，导致数据被错误地分配到不同列，修正SQL语句即可解决。

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

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: ‘1988-09-03’ for colum 1
最近在练习JDBC的对数据库的表进行增删改查使用，在eclipse中写Java程序时候就会发现许多需要和sql交互并注意的地方。很多小的细节错误，就会导致你测试不成功。下面贴一个新鲜的小错误，希望看到的同学避免入坑。

1. 问题原因：因为输出语句有错

出现错误的语句

@Test
	public void testInsert() {
		Scanner scanner = new Scanner(System.in);
		System.out.println("请输入用户名：");
		String name = scanner.next();
		System.out.println("请输入邮箱：");
		String email = scanner.next();
		System.out.println("请输入生日：");
		String birthday = scanner.next();
		String sql = "insert into customers(name,email,birth)values(?,?,?)";

``
报错如下

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '1988-09-0390' for column 'birth' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3513)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
	at com.guigu4.exer.Exer1Test.update(Exer1Test.java:52)
	at com.guigu4.exer.Exer1Test.testInsert(Exer1Test.java:23)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)
添加失败`