How To Add Column In Existing Table In Laravel 10

Websolutionstuff | Apr-24-2023 | Categories : Laravel MySQL

In this article, we will see how to add a column to the existing table in laravel 10 migration. Here, we will learn about adding multiple columns in existing laravel 10 migration. The table method on the Schema facade may be used to update existing tables.

So, let's see how to add columns in an existing table using migration in laravel 10, laravel 10 migration add a column to an existing table, add multiple columns in laravel migration, and how to add a column after a specific column in laravel migration.

Like the create method, the table method accepts two arguments: the name of the table and a closure that receives an Illuminate\Database\Schema\Blueprint instance you may use to add columns to the table

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
 
Schema::table('users', function (Blueprint $table) {
    $table->integer('votes');
});

 

Create Migration:

 Create migration using the following command.

php artisan make:migration create_flights_table

Migration:

<?php
 
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
 
return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('flights', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('airline');
            $table->timestamps();
        });
    }
 
    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::drop('flights');
    }
};

 

Add Column using Migration:

<?php
 
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
 
return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::table('flights', function (Blueprint $table) {            
            $table->string('passenger_name');            
        });
    }
 
    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        $table->dropColumn('passenger_name');
    }
};

 

Add Column After another column using Migration:

When using the MySQL database, the after method may be used to add columns after an existing column in the schema.

<?php
 
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
 
return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::table('flights', function (Blueprint $table) {            
            $table->string('passenger_name')->after('airline');            
        });
    }
 
    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        $table->dropColumn('passenger_name');
    }
};

 


You might also like:

Recommended Post
Featured Post
How To Generate PDF File In Laravel 10
How To Generate PDF File In La...

In this article, we will see how to generate a pdf file in laravel 10. Here, we will learn about laravel 10 ge...

Read More

Mar-10-2023

How to Create Login and Register in Node.js
How to Create Login and Regist...

As I embarked on my journey to develop a powerful web application, I realized the importance of a robust user authentica...

Read More

Oct-02-2023

How To Add Ckeditor In Laravel
How To Add Ckeditor In Laravel

In this article, I will explain you how to add ckeditor in laravel, CKEditor is a WYSIWYG rich text edito...

Read More

Jun-18-2020

Laravel Firebase Push Notification
Laravel Firebase Push Notifica...

In this example we will see laravel firebase push notification, firebase notification through you can notify u...

Read More

Mar-26-2021