How to Create Table using Migration in Laravel?

Hello Artisan,

In this example, i will show you how to create database table using migration command in laravel. We will look at example of how to create table through migration in laravel. we will help you to give example of how to create table migration in laravel. you will learn laravel create table using migration. you will do the following things for create table in laravel using migration.

$users = DB::table("users")
 ->groupBy("name")
 ->get();
dd($users);

...
'strict' => true,

To

'strict' => false,
....

I will guid you how to create database table using laravel migration. we will use laravel command to creating miration for table. you can easily create migration in laravel 6 and laravel 7.

I will also let you know how to run migration and rollback migration and how to create migration using command in laravel. let’s see bellow instruction.

Create Migration:

Using bellow command you can simply create migration for database table.

php artisan make:migration create_posts_table

After run above command, you can see created new file as bellow and you have to add new column for string, integer, timestamp and text data type as like bellow:

database/migrations/2020_04_01_064006_create_posts_table.php

<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class CreatePostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title');
            $table->text('body');
            $table->boolean('is_publish')->default(0);
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('posts');
    }
}

Run Migration:

Using bellow command we can run our migration and create database table.

php artisan migrate

After that you can see created new table in your database as like bellow:

Create Migration with Table:

php artisan make:migration create_posts_table --table=posts

Run Specific Migration:

php artisan migrate --path=/database/migrations/2020_04_01_064006_create_posts_table.php

Migration Rollback:

php artisan migrate:rollback

I hope it can help you…