非常简单的sql - MS-SQL Server / 基础类

数据库:mysql

表结构


非常简单的SQL语句 SQL code:
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 code:
insert into srchfingermsgtable(id, mobileid, time, millisecond, ecio, agc, txpower, txadj)
values (0, 1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);
TRY

---

SQL code:
insert into srchfingermsgtable(mobileid, time, millisecond, ecio, agc, txpower, txadj) values (1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);


自增列不需要指定

---

引用

SQL code
insert into srchfingermsgtable(mobileid, time, millisecond, ecio, agc, txpower, txadj) values (1, 20100429095820, 50, -12.5 -11.2, -10.5, -13.8);


自增列不需要指定

原来那个ID是个自增列，那就跟SQL一样了，不用指定自动生成。

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (