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

laravel change type of enum column to varchar not losing data

MaestroError answered on August 4, 2022 Popularity 1/10 Helpfulness 1/10

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

related update existing enum column options without losing data laravel

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: laravel php varchar

Link to this answer
Share Copy Link

Contributed on Nov 24 2022

MaestroError

0 Answers Avg Quality 2/10

Closely Related Answers

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

laravel change type of enum column to varchar not losing data

Contents

More Related Answers

laravel change type of enum column to varchar not losing data

Closely Related Answers

update existing enum column options without losing data laravel

Grepper

Documentation

Social

Legal

Contact

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