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

9 votes195 views1 answer
Alter table column change data type to text mysql
SQL
14 votes185 views3 answers
How to add default constraint in mysql
SQL
4 votes173 views1 answer
Mysql ip address
SQL
0 vote166 views1 answer
How to output a different column name in mysql
SQL
3 votes171 views3 answers
Create a view postgres
SQL
0 vote165 views1 answer
Sql server get date of previous sunday
SQL
0 vote217 views1 answer
Oracle sql date winter time
SQL
0 vote212 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
4 votes195 views3 answers
Rename table column postgresql
SQL
1 vote160 views2 answers
Mysql type conversion
SQL