Column specified more than once in the INSERT list.

最新推荐文章于 2025-07-25 09:43:20 发布

原创最新推荐文章于 2025-07-25 09:43:20 发布 · 1.7w 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#insert

数据库开发专栏收录该内容

33 篇文章

订阅专栏

本文详细解析了在使用Informix数据库进行数据插入操作时遇到的Column specified more than once in the INSERT list错误，并提供了相应的解决办法。

java.sql.SQLException: Column specified more than once in the INSERT list.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1153)
at com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java:318)
at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:298)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:168)
at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5909)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1991)
at app.batch.BatchDao.insertLninfo(BatchDao.java:780)
at app.batch.BatchBO.getLninfoData(BatchBO.java:36)
at app.batch.batch_in.main(batch_in.java:17)

错误方式:

写insert语句时Column重复.