How to create a table of data in my MySQL using laravel5.5?

Question

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 ?

Answer 1

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.