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

如何使用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 ?

  • 写回答

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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿