douzhi9939
2018-05-01 00:49
浏览 172
已采纳

如何使用laravel5.5在我的MySQL中创建数据表?

I am trying to create mysql tables in Laravel 5.5 I created a file in /project/database/migrations/MY_migration_file.php

<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class MY_migration_file extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('chaves',function (Blueprint $table){
            $table -> increments('id');
            $table -> string('nome');
            $table -> boolean('alugado');
            $table -> timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}

however, my mysql5.7 database is not receiving data from my migration (it's empty) file. What should I do ?

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

我正在尝试在Laravel 5.5中创建mysql表我在/ project / database / migrations / MY_migration_file中创建了一个文件。 php

 &lt;?php 
use Illuminate \ Support \ Facades \ Schema; 
use Illuminate \ Database \ Schema \ Blueprint; 
use Illuminate \ Database \ Migrations \ Migration; \  n 
class MY_migration_file扩展Migration 
 {
 / ** 
 *运行迁移。
 * 
 * @return void 
 * / 
公共函数up()
 {
 
 
 
 
 
 
 
 
 
 \ {  ('chaves',函数(Blueprint $ table){
 $ table  - &gt; incrementments('id'); 
 $ table  - &gt; string('nome'); 
 $ table  - &gt; boolean('  alugado'); 
 $ table  - &gt; timestamps(); 
}); 
} 
 
 / ** 
 *反转迁移。
 * 
 * @return void 
 * /  
公共函数down()
 {
 // 
} 
} 
   
 
 

但是,我的mysql5.7数据库没有从我的数据接收数据 迁移(它是空的)文件。 我该怎么办?

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dousha7645 2018-05-01 10:33
    已采纳

    May not a good idea to create migration with different name, this will become confusing in the long run.

    Try using the artisan command to generate the migration file

       php artisan make:migration create_chaves_table --create=chaves
    

    This will create date_create_chaves_table.php

    Add this column in your newly created date_create_chaves_table.php like this.

        Schema::create('chaves',function (Blueprint $table){
            $table -> increments('id');
            $table -> string('nome');
            $table -> boolean('alugado');
            $table -> timestamps();
        });
    

    And run this command

    php artisan migrate
    

    That should do the migration of your new table.

    Hope that helps.

    已采纳该答案
    打赏 评论
  • duanbo19834 2018-05-01 01:43

    If you have made changes for DB connection in .env file. Please run artian command:

    php artisan cache:clear
    php artisan config:clear
    php artisan optimize
    
    打赏 评论

相关推荐 更多相似问题