MySQL表结构是10行,Esclipse连接数据库执行插入语句:
sql1="""insert into tdxtb_user values('220195','123456','123456','13476123050','1100','测试559','1','2','safeguard','2012-04-09');""";#insert
cur.execute(sql1);
报错:_mysql_exceptions.OperationalError: (1136, "Column count doesn't match value count at row 1")但问题是在MySQL新建查询输入该SQL语句:
insert into tdxtb_user values('220195','123456','123456','13476123050','1100','测试559','1','2','safeguard','2012-04-09')插入成功,且将原来Esclipse上执行的语句的10个插入数据增加到11个,如下:
('220195','123456','123456','13476123050','1100','测试559','1','2','1','safeguard','2012-04-09')竟执行成功?!这个就很费解,求大神解答!!不胜感激!!
sql1="""insert into tdxtb_user values('220195','123456','123456','13476123050','1100','测试559','1','2','safeguard','2012-04-09');""";#insert
cur.execute(sql1);
报错:_mysql_exceptions.OperationalError: (1136, "Column count doesn't match value count at row 1")但问题是在MySQL新建查询输入该SQL语句:
insert into tdxtb_user values('220195','123456','123456','13476123050','1100','测试559','1','2','safeguard','2012-04-09')插入成功,且将原来Esclipse上执行的语句的10个插入数据增加到11个,如下:
('220195','123456','123456','13476123050','1100','测试559','1','2','1','safeguard','2012-04-09')竟执行成功?!这个就很费解,求大神解答!!不胜感激!!
解决方案 »
- mysql函数问题
- Mysql 删除重复字段语法错误,求解。
- 请教一个MYSQL的问题
- 用Dev-Cpp搭建MySQL++编程环境,最后没有产生libmysql.dll……
- hibernate+mysql出现乱码问题。
- 请教mysql中对象的存取
- 有什么可视化前端支持MySQL5.0的新特性的
- 比如说我有4个字段的值分别是:'我是一号','我是二号','我是三号','我四号',查询是只输入'是'字,我想返回所有带'是'的字段,这样的SQL
- 使用MYSQL如何建立DNS
- MySQL两表(通过相同的班级和科目)对比查询不同的列
- 问一个关于mysql 表级锁 页级锁 行级锁 的问题
- 关于java在eclipse中导入驱动后无法连接数据库的问题
在MYSQL上能插入而在Eclipses上出错(10个不行11个却可以但表结构只有10列)是否能说明不是MYSQL上的问题?
排除SQL语句问题,转义问题?
sql1="insert into tdxtb_user values('220195','123456','123456','13476123050','1100','测试559','1','2','safeguard','2012-04-09');"
sql1="insert into tdxtb_user values('220195','123456','123456','13476123050','1100','测试559','1','2','safeguard','2012-04-09');"显示SQL1,能否运行
`User_ID` INT(11) NOT NULL DEFAULT '0' COMMENT '',
`Client_ID` CHAR(12) NOT NULL DEFAULT '' COMMENT '',
`Account` CHAR(12) DEFAULT NULL COMMENT '',
`User_Mobile` BIGINT(11) NOT NULL DEFAULT '0' COMMENT '',
`Branch_ID` INT(5) NOT NULL DEFAULT '0' COMMENT '',
`User_Name` VARCHAR(32) CHARACTER SET utf8 NOT NULL COMMENT '',
`User_Type` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '',
`User_Origin` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '',
`User_Password` VARCHAR(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '' ,
`Modify_Time` DATE NOT NULL DEFAULT '2012-01-01' COMMENT '',
PRIMARY KEY (`User_ID`),
KEY `Client_ID_Branch_ID` (`Client_ID`,`Branch_ID`)
)SET @sql1="insert into tdxtb_user values('220195','123456','123456','13476123050','1100','测试559','1','2','safeguard','2012-04-09');";
PREPARE stml FROM @sql1;
EXECUTE stml;测试通过