How To Add Index In Laravel 10 Migration

Websolutionstuff | May-03-2023 | Categories : Laravel MySQL

In this article, we will see how to add an index in laravel 10 migration. Here, we will learn about the laravel 10 add index using migration. The Laravel schema builder supports several types of indexes. let’s discuss laravel 10 migration to create an index.

So, let's see how to add an index in laravel 10 migration, laravel 10 migration add an index to an existing column, laravel 10 migration drop index, and how to add indexing in laravel 10.

Laravel provides an index() method for adding an index to column using migration.

Syntax:

$table->index('column_name');

Example:

$table->index('state');	

// Multiple columns
$table->index(['account_id', 'created_at']);

 

Example: Simple Index

In this example, we will create a simple index. So, create a migration and add an index to the column.

php artisan make:migration create_posts_table

Migration:

<?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('description');
            $table->timestamps();
  
            $table->index(['title', 'created_at']);
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('posts');
    }
}

 

Example: Unique Index

The following example creates a new email column and specifies that its values should be unique.

php artisan make:migration create_users_table

Alternatively, you may create the index after defining the column. To do so, you should call the unique method on the schema builder blueprint. This method accepts the name of the column that should receive a unique index

Migration:

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

When creating an index, Laravel will automatically generate an index name based on the table, column names, and the index type, but you may pass a second argument to the method to specify the index name yourself

$table->unique('email', 'unique_email');

 

Available Index Types

Laravel's schema builder blueprint class provides methods for creating each type of index supported by Laravel. Each index method accepts an optional second argument to specify the name of the index.

Command Description
$table->primary('id'); Adds a primary key.
$table->primary(['id', 'parent_id']); Adds composite keys.
$table->unique('email'); Adds a unique index.
$table->index('state'); Adds an index.
$table->fullText('body'); Adds a full text index (MySQL/PostgreSQL).
$table->fullText('body')->language('english'); Adds a full text index of the specified language (PostgreSQL).
$table->spatialIndex('location'); Adds a spatial index (except SQLite).

 


You might also like:

Recommended Post
Featured Post
How To Upload And Preview Image In React JS
How To Upload And Preview Imag...

In this article, we will see how to upload and preview images in react js. You can learn how to show an i...

Read More

Sep-06-2022

How To Generate RSS Feed In Laravel 9
How To Generate RSS Feed In La...

In this article, we will see how to generate an RSS feed in laravel 9. Here, we will generate an RSS feed in larave...

Read More

Dec-12-2022

How to Force Redirect Http to Https in Laravel
How to Force Redirect Http to...

In this small artical we will see how to force redirect http to https in laravel, Here i will show you two method in&nbs...

Read More

Aug-11-2021

How to Create Auto Generate Slug with Laravel Livewire
How to Create Auto Generate Sl...

Creating an auto-generating slug using Laravel Livewire is a practical and efficient way to handle slugs for your applic...

Read More

Oct-27-2023