Laravel Migration Change to Make a Column Nullable

by

Laravel 5 now supports changing a column; here’s an example from the offical documentation:

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

Source: http://laravel.com/docs/5.0/schema#changing-columns

Laravel 4 does not support modifying columns, so you’ll need use another technique such as writing a raw SQL command. For example:

// getting Laravel App Instance
$app = app();

// getting laravel main version
$laravelVer = explode('.',$app::VERSION);

switch ($laravelVer[0]) {

    // Laravel 4
    case('4'):

        DB::statement('ALTER TABLE `pro_categories_langs` MODIFY `name` VARCHAR(100) NULL;');
        break;

    // Laravel 5, or Laravel 6
    default:                

        Schema::table('pro_categories_langs', function(Blueprint $t) {
            $t->string('name', 100)->nullable()->change();
        });               

}

More Related Contents:

  1. How to select specific columns in laravel eloquent
  2. Migration: Cannot add foreign key constraint
  3. Laravel Eloquent groupBy() AND also return count of each group
  4. Laravel 5.6 – Passport JWT httponly cookie SPA authentication for self consuming API?
  5. Laravel – Route::resource vs Route::controller
  6. Laravel Redirect Back with() Message
  7. Eloquent eager load Order by
  8. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  9. Laravel. Use scope() in models with relation
  10. Laravel Session always changes every refresh / request in Laravel 5.4
  11. Class ‘Illuminate\Html\HtmlServiceProvider’ not found Laravel 5
  12. HasManyThrough with one-to-many relationship
  13. Getting just the latest value on a joined table with Eloquent
  14. Rollback one specific migration in Laravel
  15. How to compare two Carbon Timestamps?
  16. Laravel 5 – Manual pagination
  17. What is difference between use env(‘APP_ENV’), config(‘app.env’) or App::environment() to get app environment?
  18. “Please provide a valid cache path” error in laravel
  19. How to access model hasMany Relation with where condition?
  20. Including a css file in a blade template?
  21. Eloquent Parent-Child relationship on same model
  22. Laravel 5 – artisan seed [ReflectionException] Class SongsTableSeeder does not exist
  23. Laravel Eloquent – distinct() and count() not working properly together
  24. There is no existing directory at /storage/logs and its not buildable: Permission denied
  25. Add sql table column before or after specific other column – by migrations in Laravel 4.1
  26. Laravel: Returning the namespaced owner of a polymorphic relation
  27. How to pass multiple parameters to middleware with OR condition in Laravel 5.2
  28. How to insert big data on the laravel?
  29. Polymorphic Eloquent relationships with namespaces
  30. Merge ‘with’ and ‘whereHas’ in Laravel 5

Leave a Comment