How to Change a Column Type in Laravel Migration

1 year ago admin Laravel

In this lesson, we are going to see how to change a column type in Laravel migration, let's assume that we have migrated a phone number as an integer and we want to change the column type to string.


Install the package doctrine/dbal

First, we must install the package doctrine/dbal, which is used to create the SQL queries we need to make the desired changes to the phone column.

                                                        
                                                                                                                        
composer require doctrine/dbal

Change the column

The change method is used to modify the type of an existing column.

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

Related Tuorials

How to Check if a Record Does Not Exist in Laravel

in this lesson, we will see how to check if a record does not exist in laravel, sometimes you need t...


How to Check if a Record Exists in Laravel

in this lesson, we will see how to check if a record exists in laravel, sometimes you need to check...


How to Decrement Multiple Fields in Laravel

In this lesson, we will see how to decrement multiple fields in Laravel, in the old versions of lara...


How to Increment Multiple Fields in Laravel

In this lesson, we will see how to increment multiple fields in Laravel, in the old versions of lara...


How to Use the Same Request Validation Rules for Storing and Updating in Laravel

In this lesson, we will see how to use the same request validation rules for storing and updating in...


How to Go Back to the Previous URL in Laravel Blade

In this lesson, we will see how to go back to the previous URL in Laravel Blade, sometimes we need t...


How to Add Additional Data to The Resource JSON Response in Laravel

In this lesson, we will see how to add additional data to the resource JSON response in Laravel, let...


How to Specify the Attributes to be Returned in the Laravel Find Method

In this lesson, we will see how to specify the attributes to be returned in the Laravel find method,...


How to Get Data Using Where All in Laravel

In this lesson, we will see how to get data using Where All in Laravel, the Where All method is used...


How to Get Data Using Where Any in Laravel

In this lesson, we will see how to get data using Where Any in Laravel, the Where Any method is used...