dongsaolian8786
2017-09-20 19:16
浏览 67
已采纳

如何在laravel迁移文件中使用许多数据库模式?

I'm trying to separate my tables into different schemas while writing migration files with Laravel.

I was wondering what's the best approach to do it. Currently, the table creation goes like:

 Schema::create('schema_name.table_name', function (Blueprint $table) {
        $table->increments('id');
        (...)
    });

Should I try to use a different connection, another option or it's ok like this?

图片转代码服务由CSDN问答提供 功能建议

我正在尝试用Laravel编写迁移文件时将表分成不同的模式。

我想知道做这件事的最佳方法是什么。 目前,表创建如下:

  Schema :: create('schema_name.table_name',function(Blueprint $ table){
 $ table-> increments('  id'); 
(...)
}); 
   
 
 

我应该尝试使用不同的连接,另一种选择还是这样?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douzhenzu0247 2017-09-20 19:22
    已采纳

    try this

    first in config/database.php add another connection

    'connections' => [
        'mysql' => [...],
    
        'mysql1' => [
                'driver' => 'mysql',
                'host' => env('DB_HOST', 'localhost'),
                'port' => env('DB_PORT', '3306'),
                'database' => env('DB_DATABASE_NAME', 'forge'),
                'username' => env('DB_USERNAME', 'forge'),
                'password' => env('DB_PASSWORD', ''),
                'charset' => 'utf8',
                'collation' => 'utf8_unicode_ci',
                'prefix' => '',
                'strict' => false,
                'engine' => null,
            ],
    
          ...
    ]
    

    Then in migration

    Schema::connection('mysql1')->create('table_name', function (Blueprint $table) {
        $table->increments('id');
        (...)
    });
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题