Home Arrow Icon Knowledge base Arrow Icon Global Arrow Icon What are the differences between using change() and modify() for column types in Laravel
    Laravel migrations change method modify method column types data preservation MySQL PostgreSQL SQLite SQL Server Laravel migration syntax


What are the differences between using change() and modify() for column types in Laravel


The main differences between using `change()` and `modify()` for changing column types in Laravel migrations are:

1. Preserving Data:
- `change()`: When using `$table->change()`, Laravel will attempt to modify the column type while preserving the existing data in the column. This is the preferred method for changing column types, as it avoids data loss.
- `modify()`: The `$table->modify()` method is not recommended for changing column types, as it will drop and recreate the column, which can lead to data loss.

2. Supported Databases:
- `change()`: The `change()` method is supported by all of Laravel's supported database drivers (MySQL, PostgreSQL, SQLite, SQL Server).
- `modify()`: The `modify()` method is only available for the MySQL database driver.

3. Syntax:
- `change()`: The `change()` method is used to modify the definition of an existing column, including the data type.

php
     $table->string('name')->change();
     $table->integer('age')->change();
     

- `modify()`: The `modify()` method is used to modify the definition of an existing column, including the data type.
php
     $table->string('name')->modify();
     $table->integer('age')->modify();
     

4. Rollback:
- `change()`: When using `change()`, you need to provide a `down()` method that reverts the changes made in the `up()` method.
- `modify()`: When using `modify()`, you don't need to provide a `down()` method, as the column is dropped and recreated, which can be reversed by running the migration in reverse.

In summary, the `change()` method is the recommended approach for changing column types in Laravel migrations, as it preserves the existing data and is supported across all of Laravel's supported database drivers. The `modify()` method should be used with caution, as it can lead to data loss and is only available for the MySQL database driver.

Citations:
[1] https://laracasts.com/discuss/channels/general-discussion/how-can-i-rename-column-in-laravel-using-migration
[2] https://www.itsolutionstuff.com/post/how-to-change-column-name-and-data-type-in-laravel-migrationexample.html
[3] https://laravel.io/forum/strategy-for-multi-change-migrations
[4] https://stackoverflow.com/questions/16791613/laravel-add-a-new-column-to-existing-table-in-a-migration
[5] https://laravel.com/docs/6.x/migrations