laravel创建一个存储过程

Laravel框架

401

2022-04-13

登录后可点赞和收藏

标签 Laravel数据库

 
public function up() 
{    
    DB::unprepared('CREATE PROCEDURE my_procedure(IN param INT(10)) BEGIN /* here your SP code */ END'); 
} 
 
public function down() 
{ 
    DB::unprepared('DROP PROCEDURE IF EXISTS my_procedure'); 
}

登录后可点赞和收藏

生成商品海报，附带小程序二维码

Laravel 通过迁移脚本创建MySQL视图

	public function up()
	{
	DB::unprepared('CREATE PROCEDURE my_procedure(IN param INT(10)) BEGIN /* here your SP code */ END');
	}

	public function down()
	{
	DB::unprepared('DROP PROCEDURE IF EXISTS my_procedure');
	}