插入的正常數據，字段值沒有NULL
~~~
array(15) {
["user"] => string(6) "000243"
["cname"] => string(6) "李杰"
["chief"] => string(9) "代令建"
["big_area"] => string(6) "廣東"
["newreg_num"] => int(9)
["neword_num"] => int(1)
["price_pat"] => int(0)
["price_pats"] => int(183)
["regcic_num"] => int(13)
["free_num"] => int(82)
["cicnum_30d"] => int(0)
["has_orders_clinics_num"] => int(82)
["active_clinics_rate"] => string(4) "100%"
["date_sample"] => string(10) "2017-04-21"
["id"] => string(1) "1"
}
~~~
插入的異常數據，字段值有NULL
~~~
array(15) {
["user"] => string(6) "000243"
["cname"] => string(6) "李杰"
["chief"] => string(9) "代令建"
["big_area"] => string(6) "廣東"
["newreg_num"] => int(9)
["neword_num"] => int(1)
["price_pat"] => int(0)
["price_pats"] => int(183)
["regcic_num"] => int(13)
["free_num"] => int(82)
["cicnum_30d"] => int(0)
["has_orders_clinics_num"] => int(82)
["active_clinics_rate"] => string(4) "100%"
["date_sample"] => string(10) "2017-04-21"
["id"] => NULL
}
~~~
報錯
~~~
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 [closed]
~~~
the error is clear. you're inserting X columns, but have Y values specified. value counts and field counts MUST match.
e.g. insert into foo (x,y,z) values (1,2) - where's 3?
* * * * *
字段組裝的時候可以在拼接之前先取值，做計算，再組裝。
批量插入的時候，所有記錄的字段數量都必須一致，且不允許有NULL值字段。
