Laravel 5.3 - Creating MySQL Triggers from Migration with example

Laravel 5.3 - Creating MySQL Triggers from Migration with example

Laravel 5.3 - Creating MySQL Triggers from Migration with example

In this tutorial, you will learn how to work with MySQL in Laravel 5.

Trigger is what it is only stored program and once you write a trigger against any events then whenever that events occur then triggers are automatically executed.

Normally we write DML triggers that means whenever user want to insert update or delete anything from MySQL database then DML triggers fire.

To add triggers to database schema, we write create statement like this :

    ON `database`.`table-name`
		-- trigger body
		-- write query that will be executed against specified events
		-- inserted/updated/deleted row

In Laravel, we will use DB::unprepared() method to write triggers query to add triggers to database schema.

I am going to create triggers from migration file so first i need to create migration file using following command :

php artisan make:migration create_trigger

Now you will see a migration file in database/migrations directory, open this migration file and add following code :

Migration: CreateTrigger

I create a trigger to insert user role id to assign user with default role whenever new user will be inserted.

  1. <?php
  2. use Illuminate\Support\Facades\Schema;
  3. use Illuminate\Database\Schema\Blueprint;
  4. use Illuminate\Database\Migrations\Migration;
  5. class CreateTrigger extends Migration
  6. {
  7. public function up()
  8. {
  9. DB::unprepared('CREATE TRIGGER user_default_role AFTER INSERT ON `users` FOR EACH ROW
  10. BEGIN
  11. INSERT INTO `user_role` (`role_id`, `user_id`, `created_at`, `updated_at`) VALUES (3,, now(), null);
  12. END');
  13. }
  14. public function down()
  15. {
  16. DB::unprepared('DROP TRIGGER `user_default_role`');
  17. }
  18. }

Run Migration:

php artisan migrate

Phone: (+91) 8800417876
Noida, 201301
sakarya escort sakarya escort sakarya escort sakarya escort serdivan escort izmir escort eporner
akyazı escort sakarya escort ferizli escort sakarya escort geyve escort sakarya escort hendek escort sakarya escort karasu escort sakarya escort sapanca escort serdivan escort webmaster forum ankara travesti