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

laravel change type of column not loosing data

MaestroError answered on November 24, 2022 Popularity 1/10 Helpfulness 1/10

answer laravel change type of column not loosing data

laravel change type of column not loosing data

Comment

/**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        // Create new temp column
        Schema::table('products', function (Blueprint $table) {
            $table->float('price_new');
        });
        // Copy data
        DB::statement("UPDATE products SET price_new = price");
        // Drop old column
        Schema::table('products', function (Blueprint $table) {
            $table->dropColumn('price');
        });
        // Create new column with old's name
        Schema::table('products', function (Blueprint $table) {
            $table->float('price')->after("title");
        });
        // Copy data back
        DB::statement("UPDATE products SET price = price_new");
        // Delete 
        Schema::table('products', function (Blueprint $table) {
            $table->dropColumn('price_new');
        });
    }

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Nov 24 2022

MaestroError

0 Answers Avg Quality 2/10

laravel change type of column not loosing data

Contents

More Related Answers

laravel change type of column not loosing data

Grepper

Documentation

Social

Legal

Contact

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