Please Disable Your Browser Adblock Extension for our site and Refresh This Page!

our ads are user friendly, we do not serve popup ads. We serve responsible ads!

Refresh Page
Skip to main content
On . By CodimTh
Category:

In this tuto, i will show you how to create database table using migration command in laravel.  you will do the following things for create table in laravel using migration.

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&8.

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:

To create a migration, use the make:migration

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 columns as like bellow:

database/migrations/2020_07_01_134514_create_posts_table.php

<?php


use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;


class CreatePostsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('posts', function (Blueprint $table) {

            $table->id();

            $table->string('title');

            $table->text('content');

            $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 'posts' table in your database.

Create Migration with Table

The --table and --create options may also be used to indicate the name of the table:

Example:

php artisan make:migration create_posts_table --table=articles

After that you can see created new 'articles' table in your database.

Run Specific Migration

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

Migration Rollback

php artisan migrate:rollback

Migration Reset

php artisan migrate:reset

The migrate:reset command will roll back all of your application's migrations.

Roll Back & Migrate Using A Single Command

php artisan migrate:refresh

// Refresh the database and run all database seeds...
php artisan migrate:refresh --seed

Drop All Tables & Migrate

php artisan migrate:fresh

php artisan migrate:fresh --seed

Comments

Add new comment

Restricted HTML

Search

Page Facebook

Become a patron

If you need some help or you search a Drupal freelancer don't hesitate to contact us.

 

Contact Us

All the content is FREE but I still need your help

 

Become a patreon