How to add columns in existing table using migration in laravel

Answers 1
  • Add new columns in existing table using migration in laravel 8

    //1. Run php artisan make:migration command to create migration file.
    
    php artisan make:migration add_publish_to_comments --table=comments
    
    //2. Add columns to your migration file under - database\Migrations\<your_migration_filename>.php.
    
    public function up()
    {
        Schema::table('comments', function (Blueprint $table) {
            $table->boolean('is_publish')->default(0);
        });
    }
    
    public function down()
    {
    	Schema::table('comments', function (Blueprint $table) {
    	    $table->dropColumn('is_publish');
    	});
    }
    
    //3. Migration command to create database table structure.</p>
    //Migrate to this file
    php artisan migrate --path=database\Migrations\2021_04_12_085751_add_publish_to_comments.php
    
    Or 
    //Migrate all files
    php artisan migrate
    
    0

    You can add columns in existing table using the migration command php artisan make:migration add_publish_to_comments --table=comments. Use a specific migration file name which is not already exist in your migrations folder.  After that add columns to the migration file and run migrate command. This is how you can add columns to your existing database table in laravel without changing the table structure manually using PhpMyAdmin MySQL Database. Change table name, migration file name as per your requirements.

     

  • Back to code snippet queries related laravel