How to Create Migration in Laravel 9?
This article will provide an example of how to create database table using migration command in laravel 9. I’m going to show you how to create migration in laravel 9. In this article, we will implement a how to create table migration in laravel 9. This post will give you a simple example of laravel 9 creating a table using migration.
I will guide you how to create database table using laravel migration. we will use laravel 9 command to creating migration for table.
In this example, we will simple create "posts" table with id, title, body, is_publish, created_at and updated_at columns. we will generate new migration by laravel 9 command and add above rows. Then we will run migration and we will get table created on mysql database. so let's see bellow tutorial.
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/2022_02_17_133331_create_posts_table.php
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('posts', function (Blueprint $table) {
$table->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...
Hardik Savani
I'm a full-stack developer, entrepreneur and owner of ItSolutionstuff.com. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Laravel, Angular, Vue, Node, Javascript, JQuery, Codeigniter and Bootstrap from the early stage. I believe in Hardworking and Consistency.
We are Recommending you
- Laravel 9 REST API Authentication using Sanctum Tutorial
- Laravel 9 Change Date Format Examples
- Laravel 9 Mail | Laravel 9 Send Email Tutorial
- Laravel 9 Import Export Excel and CSV File Tutorial
- Laravel 9 PDF | Laravel 9 Generate PDF File using DomPDF
- Laravel 9 Authentication using Breeze Tutorial
- Laravel 9 Create Custom Helper Functions Example
- Laravel 9 Eloquent Mutators and Accessors Example
- Laravel 9 Image Upload Example Tutorial
- Laravel 9 CRUD Application Tutorial Example