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

how change column type with laravel migration

Add Answer

Joyous Jaguar answered on June 10, 2020 Popularity 10/10 Helpfulness 5/10

answer how change column type with laravel migration

related laravel change column type

related laravel migration change column type

related laravel migration column types

related laravel migration update table column type

related update column type laravel migration

related change existing columns to other format and change column type in laravel migration

related laravel migration column types

related how to change the colum type in migration laravel

related laravel migration update set type coloumn add new set value

how change column type with laravel migration

Comment

  public function up()
  {
	// !! \\ 
    //if error => Unknown database type enum requested
    // add this line
    Schema::getConnection()->getDoctrineSchemaManager()->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
    
    Schema::table('building', function (Blueprint $table) {
      $table->float('height' , 10, 2)->change();
    });
  }

 //don't forget reverse
public function down()
{
  Schema::table('building', function (Blueprint $table) {
    $table->bigInteger('epaisseur')->change();
  });
}

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: laravel migration php

Link to this answer
Share Copy Link

Contributed on Aug 09 2022

Joyous Jaguar

0 Answers Avg Quality 2/10

Closely Related Answers

laravel change column type

Comment

php artisan make:migration change_sometable_in_finance_table --table=finance

public function up()
{
    Schema::table('sometable', function (Blueprint $table) {
        $table->text('text')->change();
    });
}

Popularity 10/10 Helpfulness 8/10 Language php

Source: stackoverflow.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Sep 14 2021

Excited Echidna

0 Answers Avg Quality 2/10

laravel migration change column type

Comment

public function up()
{
    Schema::table('sometable', function (Blueprint $table) {
        $table->text('text')->change();
    });
}

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jun 10 2020

hmt

0 Answers Avg Quality 2/10

laravel migration column types

Comment

/*
|========================================================
| Common Migration Types in (for mySql) Laravel
|========================================================
*/
$table->bigIncrements('id'); 	Incrementing ID using a "big integer" equivalent.
$table->bigInteger('votes'); 	BIGINT equivalent to the table
$table->binary('data'); 	BLOB equivalent to the table
$table->boolean('confirmed'); 	BOOLEAN equivalent to the table
$table->char('name', 4); 	CHAR equivalent with a length
$table->date('created_at'); 	DATE equivalent to the table
$table->dateTime('created_at'); 	DATETIME equivalent to the table
$table->decimal('amount', 5, 2); 	DECIMAL equivalent with a precision and scale
$table->double('column', 15, 8); 	DOUBLE equivalent with precision, 15 digits in total and 8 after the decimal point
$table->enum('choices', array('foo', 'bar')); 	ENUM equivalent to the table
$table->float('amount'); 	FLOAT equivalent to the table
$table->increments('id'); 	Incrementing ID to the table (primary key).
$table->integer('votes'); 	INTEGER equivalent to the table
$table->longText('description'); 	LONGTEXT equivalent to the table
$table->mediumInteger('numbers'); 	MEDIUMINT equivalent to the table
$table->mediumText('description'); 	MEDIUMTEXT equivalent to the table
$table->morphs('taggable'); 	Adds INTEGER taggable_id and STRING taggable_type
$table->nullableTimestamps(); 	Same as timestamps(), except allows NULLs
$table->smallInteger('votes'); 	SMALLINT equivalent to the table
$table->tinyInteger('numbers'); 	TINYINT equivalent to the table
$table->softDeletes(); 	Adds deleted_at column for soft deletes
$table->string('email'); 	VARCHAR equivalent column
$table->string('name', 100); 	VARCHAR equivalent with a length
$table->text('description'); 	TEXT equivalent to the table
$table->time('sunrise'); 	TIME equivalent to the table
$table->timestamp('added_on'); 	TIMESTAMP equivalent to the table
$table->timestamps(); 	Adds created_at and updated_at columns
$table->rememberToken(); 	Adds remember_token as VARCHAR(100) NULL
->nullable() 	Designate that the column allows NULL values
->default($value) 	Declare a default value for a column
->unsigned() 	Set INTEGER to UNSIGNED

Popularity 9/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: column-types column-typ

Link to this answer
Share Copy Link

Contributed on Dec 16 2022

salah mohamed

0 Answers Avg Quality 2/10

laravel migration update table column type

Comment

Schema::table('users', function ($table) {
    $table->string('name', 50)->change();
});
We could also modify a column to be nullable:

Schema::table('users', function ($table) {
    $table->string('name', 50)->nullable()->change();
});

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jul 31 2021

Shadow

0 Answers Avg Quality 2/10

update column type laravel migration

Comment

$table-><column_type>('<column_name>')->change();

Popularity 10/10 Helpfulness 3/10 Language php

Source: www.itsolutionstuff.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jan 11 2022

Shadowtampa

0 Answers Avg Quality 2/10

change existing columns to other format and change column type in laravel migration

Comment

// first install doctrine
composer require doctrine/dbal

php artisan make:migration change_column_type_in_users_table

// in migration, we will change existing columns from string to date format and 
// change column type to date from string

public function up()
    {
        // Convert existing 'date_of_births' to the 'd-M-Y' format
        $user_profiles = DB::table('user_profiles')->whereNotNull('date_of_birth')->get();

        foreach ($user_profiles as $user) {
            $dateOfBirth = date('d-M-Y', strtotime($user->date_of_birth));
            DB::table('user_profiles')->where('id', $user->id)->update(['date_of_birth' => $dateOfBirth]);
        }

        Schema::table('user_profiles', function (Blueprint $table) {
            $table->date('date_of_birth')->nullable()->change();
        });
    }

Popularity 6/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: format laravel migration php

Link to this answer
Share Copy Link

Contributed on Aug 15 2023

Poor Pygmy

0 Answers Avg Quality 2/10

laravel migration column types

Comment

# nullableTimestamps()
## alias of the timestamps method
	$table->nullableTimestamps(0);

# nullableMorphs()
## The method is similar to the morphs method 
## however, the columns that are created will be "nullable":
	$table->nullableMorphs('taggable');

# nullableUuidMorphs()
## The method is similar to the uuidMorphs method
## however, the columns that are created will be "nullable":
    $table->nullableUuidMorphs('taggable');

# point()
## creates a POINT equivalent column:
    $table->point('position');

# polygon()
## creates a POLYGON equivalent column:
    $table->polygon('position');

# rememberToken()
## creates a nullable, VARCHAR(100) equivalent column 
## that is intended to store the current "remember me" authentication token:
    $table->rememberToken();

# set()
## creates a SET equivalent column with the given list of valid values:
    $table->set('flavors', ['strawberry', 'vanilla']);

# smallIncrements()
## creates an auto-incrementing UNSIGNED SMALLINT 
## equivalent column as a primary key:
    $table->smallIncrements('id');

# smallInteger()
## creates a SMALLINT equivalent column:
    $table->smallInteger('votes');

# softDeletesTz()
## adds a nullable deleted_at TIMESTAMP (with timezone) equivalent column 
## with an optional precision (total digits). 
## This column is intended to store the deleted_at timestamp 
## needed for Eloquent's "soft delete" functionality:
    $table->softDeletesTz($column = 'deleted_at', $precision = 0);

# softDeletes()
## adds a nullable deleted_at TIMESTAMP 
## equivalent column with an optional precision (total digits). 
## This column is intended to store the deleted_at timestamp 
## needed for Eloquent's "soft delete" functionality:
    $table->softDeletes($column = 'deleted_at', $precision = 0);

# string()
## creates a VARCHAR equivalent column of the given length:
    $table->string('name', 100);

# text()
## creates a TEXT equivalent column:
    $table->text('description');

# timeTz()
## creates a TIME (with timezone) 
## equivalent column with an optional precision (total digits):
    $table->timeTz('sunrise', $precision = 0);

# time()
## creates a TIME equivalent column with an optional precision (total digits):
    $table->time('sunrise', $precision = 0);

# timestampTz()
## creates a TIMESTAMP (with timezone) 
## equivalent column with an optional precision (total digits):
    $table->timestampTz('added_at', $precision = 0);

# timestamp()
## creates a TIMESTAMP equivalent column 
## with an optional precision (total digits):
    $table->timestamp('added_at', $precision = 0);

# timestampsTz()
## creates created_at and updated_at TIMESTAMP 
## (with timezone) equivalent columns with an optional precision (total digits):
    $table->timestampsTz($precision = 0);

# timestamps()
## creates created_at and updated_at TIMESTAMP 
## equivalent columns with an optional precision (total digits):
    $table->timestamps($precision = 0);

# tinyIncrements()
## creates an auto-incrementing UNSIGNED TINYINT 
## equivalent column as a primary key:
    $table->tinyIncrements('id');

# tinyInteger()
## creates a TINYINT equivalent column:
    $table->tinyInteger('votes');

# tinyText()
## creates a TINYTEXT equivalent column:
    $table->tinyText('notes');

# unsignedBigInteger()
## creates an UNSIGNED BIGINT equivalent column:
    $table->unsignedBigInteger('votes');

# unsignedDecimal()
## creates an UNSIGNED DECIMAL equivalent column with 
## an optional precision (total digits) 
## and scale (decimal digits):
    $table->unsignedDecimal('amount', $precision = 8, $scale = 2);

# unsignedInteger()
## creates an UNSIGNED INTEGER equivalent column:
    $table->unsignedInteger('votes');

# unsignedMediumInteger()
## creates an UNSIGNED MEDIUMINT equivalent column:
    $table->unsignedMediumInteger('votes');

# unsignedSmallInteger()
## creates an UNSIGNED SMALLINT equivalent column:
    $table->unsignedSmallInteger('votes');

# unsignedTinyInteger()
## creates an UNSIGNED TINYINT equivalent column:
    $table->unsignedTinyInteger('votes');

# uuidMorphs()
## The uuidMorphs method is a convenience method that adds a 
## {column}_id CHAR(36) equivalent column and a {column}_type 
## VARCHAR equivalent column.
## This method is intended to be used when defining the columns necessary 
## for a polymorphic Eloquent relationship that use UUID identifiers. 
## In the following example, `taggable_id` and `taggable_type` columns would be created:
    $table->uuidMorphs('taggable');

# uuid()
## creates a UUID equivalent column:
    $table->uuid('id');

# year()
## creates a YEAR equivalent column:
    $table->year('birth_year');

Popularity 10/10 Helpfulness 3/10 Language php

Source: laravel.com

Tags: column-types column-typ

Link to this answer
Share Copy Link

Contributed on Dec 30 2021

Scary Shark

0 Answers Avg Quality 2/10

how to change the colum type in migration laravel

Comment

-1

public function changeColumnType($table, $column, $newColumnType) {                
    DB::statement("ALTER TABLE $table CHANGE $column $column $newColumnType");
}

Popularity 10/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jan 12 2022

Lonely Lyrebird

0 Answers Avg Quality 2/10

laravel migration update set type coloumn add new set value

Comment

-1

hi

Popularity 7/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: add laravel migration mi

Link to this answer
Share Copy Link

Contributed on Dec 18 2023

Rich Rattlesnake

0 Answers Avg Quality 2/10

how change column type with laravel migration

Contents

More Related Answers

how change column type with laravel migration

Closely Related Answers

laravel change column type

laravel migration change column type

laravel migration column types

laravel migration update table column type

update column type laravel migration

change existing columns to other format and change column type in laravel migration

laravel migration column types

how to change the colum type in migration laravel

laravel migration update set type coloumn add new set value

Grepper

Documentation

Social

Legal

Contact

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