批量更新的问题 求解

azure

data数组是
array(2) { [0]=> array(2) { ["id"]=> string(2) "10" ["kejian"]=> int(1) } [1]=> array(2) { ["id"]=> string(2) "11" ["kejian"]=> int(1) } }




$this->db->update_batch('pinglun',$data,'id');


报了两个错误

错误一

Severity: Notice

Message: Undefined index: id

错误二

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN '10' WHEN `id` = THEN '11' ELSE `id` END, `kejian` = CASE WHEN `id` = TH' at line 2

UPDATE `pinglun` SET `id` = CASE WHEN `id` = THEN '10' WHEN `id` = THEN '11' ELSE `id` END, `kejian` = CASE WHEN `id` = THEN 1 WHEN `id` = THEN 1 ELSE `kejian` END WHERE `shangjia_id` = '1' AND `id` IN(,)

Hex

代码贴全一些看看，看起来是 SQL 语句的问题。