DB::transaction

use Illuminate\Support\Facades\DB;

DB::transaction(function () {
    DB::update('update users set votes = 1');

    DB::delete('delete from posts');
});

Source: laravel.com

DB::transaction

DB::beginTransaction();

try {
    DB::insert(...);
    DB::insert(...);
    DB::insert(...);

    DB::commit();
    // all good
} catch (\Exception $e) {
    DB::rollback();
    // something went wrong
}

Source: stackoverflow.com

Similar codes

0 vote250 views1 answer
Find most frequent value in SQL column
SQL
0 vote244 views1 answer
Get created time of database psql 8
SQL
1 vote273 views1 answer
Trim leading zeros in sql
SQL
0 vote250 views1 answer
Sql server delete records with specific date
SQL
1 vote258 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
2 votes264 views1 answer
Oracle kill job by sid
SQL
0 vote265 views2 answers
How to create a table from another table in sql derby
SQL
0 vote273 views3 answers
Duplicate row mysql
SQL
0 vote247 views2 answers
MySQL top percent
SQL
5 votes275 views1 answer
Invalid column name sql
SQL