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 Search Records using Laravel 10 Livewire
How to Search Records using La...

Hey developers! Today, I'm excited to walk you through an incredibly powerful feature in Laravel 10: searching...

Read More

Dec-27-2023

How to Filter Datatable using Dropdown in Laravel 10
How to Filter Datatable using...

Hello developers! 👋 Ever found yourself dealing with a DataTable in Laravel and wished for a nifty way to filter th...

Read More

Feb-07-2024

How To Add Digital Signature In PDF In Laravel 9
How To Add Digital Signature I...

In this article, we will see how to add a digital signature in pdf in laravel 9. Here, we will learn to add a digit...

Read More

Dec-21-2022

How To Convert HTML To PDF using JavaScript
How To Convert HTML To PDF usi...

In this example we will see how to convert html to pdf using javaScript. PDF file format is very useful to dow...

Read More

Aug-23-2021