Breaking News: Grepper is joining You.com. Read the official announcement!

update existing enum column options without losing data laravel

Bilal Ashfaq answered on August 4, 2022 Popularity 2/10 Helpfulness 1/10

answer update existing enum column options without losing data laravel

related laravel change type of enum column to varchar not losing data

update existing enum column options without losing data laravel

Comment

// Include old and new enum values
DB::statement("ALTER TABLE packages MODIFY COLUMN weight_unit ENUM('Kg.', 'Gm.', 'Grams', 'Kgs', 'Pounds')");
// Replace Kg. with Kgs
Packages::where('weight_unit', 'Kg.')->update(['weight_unit' => 'Kgs']);
// Replace Gm. with Grams
Packages::where('weight_unit', 'Gm.')->update(['weight_unit' => 'Grams']);
// Delete old values
DB::statement("ALTER TABLE packages MODIFY COLUMN weight_unit ENUM('Grams', 'Kgs', 'Pounds')");

Popularity 2/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Aug 04 2022

Bilal Ashfaq

0 Answers Avg Quality 2/10

Closely Related Answers

laravel change type of enum column to varchar not losing data

Comment

/**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        // Create new temp column
        Schema::table('pages', function (Blueprint $table) {
            $table->string('type_new', 32)->default("default");
        });
        // Copy data
        DB::statement("UPDATE pages SET type_new = type");
        // Drop old column
        Schema::table('pages', function (Blueprint $table) {
            $table->dropColumn('type');
        });
        // Create new column with old's name
        Schema::table('pages', function (Blueprint $table) {
            $table->string('type', 32)->default("default")->after("books_id");
        });
        // Copy data back
        DB::statement("UPDATE pages SET type = type_new");
        // Delete 
        Schema::table('pages', function (Blueprint $table) {
            $table->dropColumn('type_new');
        });
    }

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: php varchar laravel

Link to this answer
Share Copy Link

Contributed on Nov 24 2022

MaestroError

0 Answers Avg Quality 2/10

update existing enum column options without losing data laravel

Contents

More Related Answers

update existing enum column options without losing data laravel

Closely Related Answers

laravel change type of enum column to varchar not losing data

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.