/PHP/Laravel/How to change the colum type in migration laravel

How to change the colum type in migration laravel

Laravel migration change column length

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

Laravel migration change column type

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

How to change the colum type in migration laravel

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

Source: stackoverflow.com

Similar codes

16 votes375 views3 answers
Make a forign key in migrations using laravel 8
PHP Laravel
3 votes364 views2 answers
Laravel where condition on relationship
PHP Laravel
0 vote418 views1 answer
How to make a simple mail system in Laravel without view or notification
PHP Laravel
0 vote402 views1 answer
Laravel - access file from storage path - alternative to symlink
PHP Laravel
0 vote421 views2 answers
Laravel auth login with phone or email
PHP Laravel
25 votes370 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP Laravel
16 votes363 views6 answers
Laravel redirect back
PHP Laravel
8 votes353 views4 answers
Join multiple tables in laravel eloquent
PHP Laravel
6 votes326 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
1 vote437 views1 answer
Laravel Post model for flat file CMS
PHP Laravel