How can I rename column in laravel using migration

Question

I have columns as mentioned bellow    public function up         Schema  create  stnk   function Blueprint  table                 table- gt increments  id             table- gt string  no reg   50 - gt unique             table- gt string  no bpkb   50 - gt unique             table- gt string  nama pemilik   100            table- gt string  alamat             table- gt string  merk   50            table- gt string  tipe   50            table- gt string  jenis   50            table- gt smallInteger  tahun pembuatan             table- gt smallInteger  tahun registrasi             table- gt smallInteger  isi silinder             table- gt string  no rangka   50            table- gt string  no mesin   50            table- gt string  warna   50            table- gt string  bahan bakar   50            table- gt string  warna tnkb   50            table- gt string  kode lokasi   50            table- gt date  berlaku sampai             table- gt timestamps              table- gt index  created at             table- gt index  updated at                 I have made seeder to stnk table  Now I want to rename id to id stnk  I ve added a  doctrine   dbal  in the  composer  and do a composer update   I ve made migration php artisan migration make rename column   Then I ve added new method to rename column   Schema  table  stnk   function Blueprint  table         table- gt renameColumn  id    id stnk           And then I ve tried to run command php artisan migrate but I got error as mentioned bellow    Ulluminate Database QueryException  SQLSTATE HY000   General error  1025 Error on rename of    my database  sql -447 33  to    my database stnk   error  150   SQL  ALTER TABLE stnk CHANGE id id stnk INT UNSIGENED AUTO INCREMENT NOT NULL    PDOException  SQLSTATE HY000   General error  1025  Error on rename  of    my database  sql -447 33  to    my database stnk   error  150

User · Answer

The above answer is great or if it will not hurt you  just rollback the migration and change the name and run migration again     php artisan migrate rollback

User · Answer

Follow these steps  respectively for rename column migration file   1- Is there Doctrine dbal library in your project  If you don t have run the command first  composer require doctrine dbal   2- create update migration file for update old migration file   Warning  need to have the same name   php artisan make migration update oldFileName table   for example my old migration file name  create users table update file name should   update users table  3- update oldNameFile table php  Schema  table  users   function  Blueprint  table     table- gt renameColumn  from    to           from  my old column name and  to  my new column name   4- Finally run the migrate command  php artisan migrate   Source link  laravel document

User · Answer

You need to create another migration file - and place it in there   Run  Laravel 4     php artisan migrate make rename stnk column Laravel 5     php artisan make migration rename stnk column   Then inside the new migration file place   class RenameStnkColumn extends Migration        public function up                 Schema  table  stnk   function Blueprint  table                 table- gt renameColumn  id    id stnk                            public function down                 Schema  table  stnk   function Blueprint  table                 table- gt renameColumn  id stnk    id

User · Answer

Throwing my  0 02 in here since none of the answers worked  but did send me on the right path  What happened was that a previous foreign constraint was throwing the error  Obvious when you think about it   So in your new migration s up method  first drop that original constraint  rename the column  then add the constraint again with the new column name  In the down method  you do the exact opposite so that it s back to the sold setting          Run the migrations         return void     public function up         Schema  table  proxy4s   function  Blueprint  table               Drop it          table- gt dropForeign   server id                 Rename          table- gt renameColumn  server id    linux server id                Add it          table- gt foreign  linux server id  - gt references  id  - gt on  linux servers                      Reverse the migrations         return void     public function down         Schema  table  proxy4s   function  Blueprint  table               Drop it          table- gt dropForeign   linux server id                 Rename          table- gt renameColumn  linux server id    server id                Add it          table- gt foreign  server id  - gt references  id  - gt on  linux servers                Hope this saves someone some time in the future

User · Answer

Renaming Columns  Laravel 5 x   To rename a column  you may use the renameColumn method on the Schema builder   Before renaming a column  be sure to add the doctrine dbal dependency to your composer json file    Or you can simply required the package using composer     composer require doctrine dbal   Source  https   laravel com docs 5 0 schema renaming-columns  Note  Use make migration and not migrate make for Laravel 5 x

User · Answer

first thing you want to do is to create your migration file   Type in your command line  php artisan make migration rename stk column --table  YOUR TABLE  --create   After creating the file  Open the new created migration file in your app folder under database migrations   In your up method insert this   Schema  table  stnk   function Blueprint  table                 table- gt renameColumn  id    id stnk                and in your down method       Schema  table  stnk   function Blueprint  table                 table- gt renameColumn  id stnk    id               then in your  command line just type  php artisan migrate   Then wollah  you have just renamed id to id stnk   BTW you can use  php artisan migrate rollback   to undo the changes  Goodluck

User · Answer

I know this is an old question  but I faced the same problem recently in Laravel 7 application  To make renaming columns work I used a tip from this answer where instead of composer require doctrine dbal I have issued composer require doctrine dbal  2 12 1 because the latest version of doctrine dbal still throws an error  Just keep in mind that if you already use a higher version  this answer might not be appropriate for you

[php] How can I rename column in laravel using migration?

Examples related to php

Examples related to mysql

Examples related to database

Examples related to laravel

Examples related to migration