Add sql table column before or after specific other column – by migrations in Laravel 4.1

by

Yes. Create a new migration using php artisan migrate:make update_users_table.

Then use the table command as follows (if you’re using MySQL!):

Schema::table('users', function($table)
{
    $table->string('phone_nr')->after('id');
});

Once you’ve finished your migration, save it and run it using php artisan migrate and your table will be updated.

Documentation: https://laravel.com/docs/4.2/migrations#column-modifiers

More Related Contents:

  1. Laravel Migration Change to Make a Column Nullable
  2. Trying to get property of non-object error on laravel 5.4
  3. Browser Version and laravel Version
  4. Vue js in laravel [closed]
  5. Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
  6. How to protect image from public view in Laravel 5?
  7. How to place the ~/.composer/vendor/bin directory in your PATH?
  8. Eloquent Collection: Counting and Detect Empty
  9. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  10. How to paginate a collection after get() in Laravel?
  11. How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?
  12. laravel with() method versus load() method
  13. NotFoundHttpException with Lumen
  14. Laravel Eloquent “WHERE NOT IN”
  15. Laravel 5.4^ – How to customize notification email layout?
  16. How to use paginate() with a having() clause when column does not exist in table
  17. How to fix ‘Unchecked runtime.lastError: The message port closed before a response was received’ chrome issue?
  18. Select Last Row in the Table
  19. What is the difference between queue:work –daemon and queue:listen
  20. Eloquent push() and save() difference
  21. Laravel setup failed to open stream
  22. Google reCaptcha with Laravel
  23. Laravel join query with conditions
  24. Laravel 5 – artisan seed [ReflectionException] Class SongsTableSeeder does not exist
  25. Laravel: Get pivot data for specific many to many relation
  26. Laravel: Returning the namespaced owner of a polymorphic relation
  27. Undefined class Route (Laravel in PhpStorm)
  28. Laravel 7 Sanctum logout
  29. Polymorphic Eloquent relationships with namespaces
  30. PHP: Generate Laravel Paginator Secure (HTTPS) Links

Leave a Comment