DEV Community

Morcos Gad
Morcos Gad

Posted on

insertOrIgnore to Ignore SQL Errors - Laravel

I found this tip and wanted to share it with you so that you can benefit from it in your next projects, which is if you are not sure that this row exists in the database and want to avoid sending an error message when this row exists here, use insertOrIgnore

Laravel InsertOrIgnore With Eloquent

DB::table('users')->insertOrIgnore($data);
Enter fullscreen mode Exit fullscreen mode

Laravel InsertOrIgnore Query With Eloquent Model

User::insertOrIgnore($data);
Enter fullscreen mode Exit fullscreen mode

I hope you benefited and enjoyed this code with him. If you want to dig deeper, visit these sources
https://www.mysqltutorial.org/mysql-insert-ignore/
https://www.tutsmake.com/laravel-eloquent-insertorignore-example/
https://www.youtube.com/watch?v=hqiUzO8EFbM

Oldest comments (0)