Skip to content
Readerstacks logo Readerstacks
  • Home
  • Softwares
  • Angular
  • Php
  • Laravel
  • Flutter
Readerstacks logo
Readerstacks
How to add column in laravel migration

How to Add Column in Existing Table Laravel migration ?

Aman Jain, February 15, 2022June 30, 2022

Adding column to existing table are easy as creating a new table and adding columns to it. In laravel migration we can add new colum to existing table using the same method we used in create migrations . Major difference between creating new table and updating new table is Schema::create and Schema::table In this tutorial we will create a new migration file and then will add a new column status to the existing table .

I hope you know about How to make database connection in Laravel 8 ?

We will use the php artisan command to generate the add column in laravel migration and php artisan migrate command to modify the table.

I am assuming that you have already table movies in database and now we are adding a new column.

Let’s understand the add column in laravel migration in laravel step by step

Step 1 : Generate migration file

To generate the migration file we will use the laravel artisan command so open the terminal in project and run below command

php artisan make:migration add_status_movies_table

Above command will create a migration file in folder database/migrations

Output: 
Created Migration: 2022_02_15_174050_add_status_movies_table

Step 2 : Open generated migration file and update

In the last step we created a migration file using the artisan command and now we wanted to add some more columns to schema of movies table.

so let’s open the file and start editing

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class AddStatusMoviesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}

In the file there is a class named as AddStatusMoviesTable and it extends Migration class. AddStatusMoviesTable contains two methods one is up and other one is down.

Up is used to update the database scheme and down method is used to rollback the changes of this migration. As you can see we are creating table movies in up method and dropping the table in down method.

let’s add some more fields to our table before updating the database.

public function up()
{
        Schema::table('movies', function (Blueprint $table) {
             
            $table->integer("status");
            
        });
}

public function down()
{
        Schema::table('movies', function (Blueprint $table) {
             
            $table->dropColumn("status");
            
        });
}

Here we used Schema::table to update the table.

Step 3 : Run Migration

In this step we will execute our migration in database using below command

php artisan migrate

This will create table in database and the output

Output: 
Migrating: 2022_02_15_174050_add_status_movies_table
Migrated:  2022_02_15_174050_add_status_movies_table (20.08ms)

Screenshot Before:

Screenshot 2022 02 15 at 10.29.48 PM
Laravel before migration in database

Screenshot After:

Screenshot 2022 02 15 at 11.14.30 PM

Also Read : Laravel artisan command to generate controllers, Model, Components and Migrations

Related

Php Laravel laravelmigrationphp

Post navigation

Previous post
Next post

Related Posts

Php How to Upload image in Laravel

How to Upload image in Laravel 11 ?

July 7, 2024July 7, 2024

In this blog post, we’ll explore how to upload image using Laravel 11. Laravel 11 provides robust functionality for uploading and processing images, which is essential for various website tasks, from setting up profile pictures to handling document uploads. With Laravel 11, you can manage image uploads securely. Laravel utilizes…

Read More
Php How to run specific seeder class in laravel

How to run specific seeder class in laravel 9 ?

February 19, 2022February 22, 2022

In our last article we learnt about how to create seeder in laravel but sometimes we only need to run a specific seeders rather then running all so in this article we will cover to run a specific seeder. We will use a simple example of article class and will…

Read More
Php Custom Error pages in laravel

How to create a custom 404 page in Laravel 8 ?

December 28, 2021December 28, 2021

Laravel provides its inbuilt 404 error page and shows text 404 page not found but we want more customization and better ui for 404 page so in this article i will show yo to customize the 404 not found error page in laravel. This article will cover you to create…

Read More

Aman Jain
Aman Jain

With years of hands-on experience in the realm of web and mobile development, they have honed their skills in various technologies, including Laravel, PHP CodeIgniter, mobile app development, web app development, Flutter, React, JavaScript, Angular, Devops and so much more. Their proficiency extends to building robust REST APIs, AWS Code scaling, and optimization, ensuring that your applications run seamlessly on the cloud.

Categories

  • Angular
  • CSS
  • Dart
  • Devops
  • Flutter
  • HTML
  • Javascript
  • jQuery
  • Laravel
  • Laravel 10
  • Laravel 11
  • Laravel 9
  • Mysql
  • Php
  • Softwares
  • Ubuntu
  • Uncategorized

Archives

  • May 2025
  • April 2025
  • October 2024
  • July 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • July 2023
  • March 2023
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021

Recent Posts

  • Understanding High Vulnerabilities: A Deep Dive into Recent Security Concerns
  • Understanding High Vulnerabilities in Software: A Week of Insights
  • Blocking Spam Requests with LaraGuard IP: A Comprehensive Guide
  • Enhancing API Development with Laravel API Kit
  • Exploring the Future of Web Development: Insights from Milana Cap
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version