数据库:mysql表结构
非常简单的SQL语句 insert into srchfingermsgtable(id, mobileid, time, millisecond, ecio, agc, txpower, txadj) values (null, 1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);
问题:报错,报的错误为Column count doesn't match value count at row 1
谁能帮我改下吗...多谢了!!!
非常简单的SQL语句 insert into srchfingermsgtable(id, mobileid, time, millisecond, ecio, agc, txpower, txadj) values (null, 1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);
问题:报错,报的错误为Column count doesn't match value count at row 1
谁能帮我改下吗...多谢了!!!
values (0, 1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8); TRY
SET IDENTITY_INSERT [srchfingermsgtable] ON
insert into srchfingermsgtable(id, mobileid, time, millisecond, ecio, agc, txpower, txadj) values (1, 1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);
SET IDENTITY_INSERT [srchfingermsgtable] OFF
试试这个
我把表结构很清楚的贴出来了,
12楼的代码都我试过了,还是错误.
可看下面的图片
SET IDENTITY_INSERT [数据库名].[srchfingermsgtable] ON
insert into srchfingermsgtable(id, mobileid, time, millisecond, ecio, agc, txpower, txadj) values (1, 1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);
SET IDENTITY_INSERT [数据库名].[srchfingermsgtable] OFF
SET IDENTITY_INSERT [数据库名].[dbo].[srchfingermsgtable] ON
insert into srchfingermsgtable(id, mobileid, time, millisecond, ecio, agc, txpower, txadj) values (1, 1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);
SET IDENTITY_INSERT [数据库名].[dbo].[srchfingermsgtable] OFF
insert into
srchfingermsgtable(id, mobileid, time, millisecond, ecio, agc, txpower, txadj)
values (null, 1, '2010-04-29 09:58:20', 50, -12.5 -11.2, -10.5, -13.8);
恩,我会记住的,谢谢你的回贴,以及上面所有回贴的 Thanks.
insert into srchfingermsgtable( mobileid, time, millisecond, ecio, agc, txpower, txadj) values (1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8); ID自增。。