laravel mysql触发器_php – Laravel,从Migration创建MySQL触发器

我已经从迁移创建了MySQL存储过程,它工作得很好.

DB::unprepared('

CREATE PROCEDURE sp_Create_Default_Task_1(IN _kid_id INT)

BEGIN

INSERT INTO tasks (kid_id, name) VALUES (_kid_id, \'daily\');

END'

);

此后我尝试使用以下代码创建MySQL触发器

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateTrigger extends Migration {

public function up()

{

DB::unprepared('

CREATE TRIGGER tr_Task_Default AFTER INSERT ON `kids` FOR EACH ROW

INSERT INTO tasks (`kid_id`, `name`) VALUES (NEW.id, \'Default\');

');

}

public function down()

{

DB::unprepared('DROP TRIGGER `tr_User_Default_Member_Role`');

}

}

但是在我运行php artisan migrate之后它返回错误

{"error":{