How To Add A New Column Using Laravel Migration?

Mahmoud Abd Elhalim — Sat, 18 Mar 2023 15:57:49 +0000

In this post, we will focus on the Add new column after another column in our DB table. step by step explain how to add a new column in the migration file. follow the below step to learn how to do it.

will give you a simple example of how to add a column after a specific column in Laravel migration. Alright, let’s dive into the details. for example, we have the "posts" table with columns:

['id', 'title', 'body', 'created_at', 'updated_at'] and we need to add the "status" column after the body column into the table.

Firstly Create a Migration File

php artisan make:migration AddStatusColumnToPostsTable

Then use the after() method from Schema to do it with syntax $table->boolean('status')->after('body');

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::table('posts', function (Blueprint $table) {
            $table->boolean('status')->after('body');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('posts', function (Blueprint $table) {

        });
    }
};

Now, you can run the migration command:

php artisan migrate

You can See The Most Important Software Design Patterns

Thanks

Change Table Name Using Laravel Migration

Mahmoud Abd Elhalim — Sat, 18 Mar 2023 15:29:07 +0000

Hello bro,

In this post we will focus on the main operations we need to do on any Laravel project, for example, will learn you how to change column type in the migration file. step by step explain how to rename column names in the migration file. another one is how to rename the table names using the migration file, follow the below step to learn how to do it.
I will give you two examples of main operations can we use in all Laravel versions from 5 to above.

First of all we need to install "doctrine/dbal" composer package.

composer require doctrine/dbal

After successfully installing the composer package we can proceed to explain the operations.

we can easily rename table name's using Schema rename method. so let's do this, for example, we have a table called "articles" and we need to change the name to a new one called "posts"

Create Migration File
php artisan make:migration RenameArticlesTable

Then use the rename method from Schema to do it with syntax Schema::rename('old_table_name', 'new_table_name');