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

2 votes97 views1 answer
Sql float to int
SQL
0 vote188 views1 answer
How to compile a function in oracle
SQL
3 votes142 views1 answer
Oracle drop user
SQL
0 vote139 views1 answer
Mysql set variable to today's date
SQL
0 vote146 views1 answer
Delete duplicate rows
SQL
7 votes141 views3 answers
SQL create a new table
SQL
1 vote134 views1 answer
Oracle show execution plan
SQL
0 vote131 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
1 vote139 views3 answers
What is union in sql
SQL
10 votes105 views2 answers
Mysql select timestamp group by day
SQL