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 vote194 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote174 views1 answer
How get data from database if id not found then search another column
SQL
1 vote181 views1 answer
Oracle sql pad left zeros
SQL
3 votes171 views2 answers
Sql get month name
SQL
3 votes168 views4 answers
Mysql decimal
SQL
0 vote240 views1 answer
How to add auto increment primary key
SQL
0 vote170 views1 answer
How to query without duplicate rows in sql
SQL
1 vote146 views3 answers
Grant syntax in sql
SQL
0 vote189 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
3 votes213 views2 answers
Wp do sql query from function
SQL