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 vote293 views1 answer
Bigquery declare
SQL
0 vote316 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote360 views1 answer
Mssql find deadlocks
SQL
0 vote293 views1 answer
Replace multiple string in query sql
SQL
3 votes289 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote322 views1 answer
Typeorm raw sql
SQL
2 votes320 views2 answers
Storing timezones in postgres
SQL
15 votes456 views2 answers
Sql order by alphabetical
SQL
7 votes301 views1 answer
Safe update mysql
SQL
0 vote328 views1 answer
Oracle sql all days except weekends
SQL