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

1 vote181 views2 answers
Sql queries practice
SQL
-1 vote178 views2 answers
Postgresql get last 10 records
SQL
0 vote180 views1 answer
Python connect to mysql in settings.py
SQL
1 vote191 views2 answers
How to combine 2 tables in MySQL
SQL
19 votes175 views2 answers
Mysql tinyint max value
SQL
0 vote169 views1 answer
Mysql money value
SQL
0 vote183 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote176 views1 answer
Java check if something is in mysql table
SQL
16 votes176 views4 answers
Sort by sql
SQL
0 vote165 views1 answer
Oracle list of long running queries
SQL