Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PHP

how to add colum in existing table laravel

**STEP 1**

    php artisan make:migration add_sex_to_users_table --table=users

**STEP 2**
In the new generated migration file, you will find up and down hook methods. in up hook, add there columns that you want to add, and in down hook, add there columns that you need to remove. for example, Me i need to add sex on column of users, so I will add there following line in the up hook.

    $table->integer('quantity')->default(1)->nullable();

So i have something like this

        public function up()
    {
        Schema::table('service_subscriptions', function (Blueprint $table) {
            $table->integer('quantity')->default(1)->nullable();
        });
    }

**STEP 3**
Run the migration command as follows

    php artisan migrate

Then you will have a new collumn added!!!!

THANK ME LATER!
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #add #colum #existing #table #laravel
ADD COMMENT
Topic
Name
4+8 =