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 运行问题,请高人解答,my.INI采用默认配置
- 寻三道mysql的笔试题?
- mysql 自定义函数中 select 语句赋值
- 在PostgreSQL中,查询30分钟前的数据的SQL怎样写?时间字段为Time
- 请教:关于MYSQL 一条删除数据库命令
- 在网上找了一个脚本备份mysql,每天自动备份的,出错,不知啥原因
- 如何通过ODBC连接MYSQL数据库?菜鸟初学!!!
- 我使用MySQL数据库,安装了JDBC驱动程序,然后运行一段JSP程序,出现下面的问题,请问是何问题???
- mysql中是否mssql的in()语句?
- 服务器数据处理压力测试遇到麻烦
- sql表达中的简化问题,我问下
- mysql判断是否存在字段
`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`)
)
('220195','123456','123456','13476123050','1100','测试559','1','2', 'safeguard','2012-04-09')--在SQL上执行成功在Esclipse报错。('220195','123456','123456','13476123050','1100','测试559','1','2','1','safeguard','2012-04-09')--在SQL上是错的但在Esclipse插入却成功了,我不懂得地方就是在这里,求解释?谢谢回复!
`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;测试通过
是Eclipse,一时手快打错,汗颜..
事实上,我用的是Python在Eclipse上连接的MySQLdb。
测试结果还是很纠结,在MySQLdb上插得进去但Eclipse上就是查不进去,还是报错:
:_mysql_exceptions.OperationalError: (1136, "Column count doesn't match value count at row 1")
头大...