SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 2

插入sql报错:

SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 2 (SQL: insert into test (author, content, title) values (天蚕土豆, 晋级斗圣!!!, 斗破苍穹), (唐家三少, 斗罗大陆))

是插入2条数据,字段没有保持一致。

$data = [
    ['title'=>'斗破苍穹','author'=>'天蚕土豆','content'=>'晋级斗圣!!!'],
    ['title'=>'斗罗大陆','author'=>'唐家三少'],
];
app('db')->table('test')->insert($data);

第二条数据的 content 要给值

$data = [
    ['title'=>'斗破苍穹','author'=>'天蚕土豆','content'=>'晋级斗圣!!!'],
    ['title'=>'斗罗大陆','author'=>'唐家三少','content'=>''],
];
app('db')->table('test')->insert($data);
posted @ 2020-08-20 17:33  pine007  阅读(3344)  评论(0编辑  收藏  举报