·Ç³£¼òµ¥µÄ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 (