thinkphp5.1 insertAll 问题

浏览:2932 发布日期:2019/03/25 分类:求助交流 关键字: 批量插入
$data = [];
$data[] = ['name' => '司马道长', 'sex' => 1, 'age' => 39, 'salary' => 3890];
$data[] = ['name' => '段王爷', 'sex' => 0, 'age' => 58, 'salary' => 9560];
$data[] = ['name' => '鲁大师', 'sex' => 0, 'age' => 88, 'salary' => 7280];


$result = Db::table('test')->insertAll($data);


运行提示:
SQLSTATE[HY093]: Invalid parameter number

CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`sex` int(11) NULL DEFAULT NULL,
`age` int(11) NULL DEFAULT NULL,
`salary` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
最佳答案
评论( 相关
后面还有条评论,点击查看>>