我想从 L_Examen_Categorie 表中的 get() 方法插入数据,但它说:
当 IDENTITY_INSERT 设置为 OFF 时,无法为表“L_Examen_Categorie”中的标识列插入显式值。(SQL: insert into [L_Examen_Categorie] ([id], [code], [libelle], [coefficient], [Note], [id_examen]) values (5, 777, 777, 3, 12, 1))"
这是我的代码
$categorie = DB::table('P_Examen_Categorie as p')
->where('p.id_examen', '=', $request->input('id_examen'))
->get();
foreach($categorie as $cat_item)
{
L_Examen_Categorie::insert((array)$cat_item);;
}
响应类别:
[{id: "5", code: "777", libelle: "777", coefficient: "3", Note: "12", id_examen: "1"},…]
0: {id: "5", code: "777", libelle: "777", coefficient: "3", Note: "12", id_examen: "1"}
1: {id: "7", code: "39", libelle: "39", coefficient: "3", Note: "12", id_examen: "1"}
2: {id: "9", code: "777", libelle: "39", coefficient: "3", Note: "12", id_examen: "1"}
3: {id: "10", code: "777", libelle: "777", coefficient: "1", Note: "1211", id_examen: "1"}
4: {id: "11", code: "777", libelle: "777", coefficient: "3", Note: "12", id_examen: "1"}
您需要使用“toArray()”方法。此方法将您的集合对象转换为数组,然后插入数据。
$categorie = DB::table('P_Examen_Categorie as p')
->where('p.id_examen', '=', $request->input('id_examen'))
->get()->toArray();
L_Examen_Categorie::insert( $categorie);
但要确保在同一列是可用L_Examen_Categorie
表
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句