blocks|key|2723821|text|您需要创建另一个迁移文件-并将其放入其中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2723822|跑|2723823|Laravel+4:++++php+artisan+migrate:make+rename_stnk_column
Laravel+5:++++php+artisan+make:migration+rename_stnk_column|code-block|syntax|javascript|2723824|然后在新的迁移文件中放置：|2723825|class+RenameStnkColumn+extends+Migration
{

++++public+function+up()
++++{
++++++++Schema::table('stnk',+function(Blueprint+$table)+{
++++++++++++$table->renameColumn('id',+'id_stnk');
++++++++});
++++}


++++public+function+down()
++++{
++++++++Schema::table('stnk',+function(Blueprint+$table)+{
++++++++++++$table->renameColumn('id_stnk',+'id');
++++++++});
++++}

}|2723826|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You need to create another migration file - and place it in there:

Run

<pre><code>Laravel 4: php artisan migrate:make rename_stnk_column
Laravel 5: php artisan make:migration rename_stnk_column
</code></pre>

Then inside the new migration file place:

<pre><code>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');
 });
 }

}
</code></pre>

blocks|key|146676|text|上面的答案很好，或者如果它不会对您造成伤害，只需回滚迁移并更改名称，然后再次运行迁移。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|146677|+php+artisan+migrate:rollback|code-block|syntax|javascript|146678|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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

<pre><code> php artisan migrate:rollback
</code></pre>

blocks|key|146688|text|您要做的第一件事是创建迁移文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|146689|在命令行中键入|146690|php+artisan+make:migration+rename_stk_column+--table="YOUR+TABLE"+--create|code-block|syntax|javascript|146691|在创建文件之后。在您的app文件夹中的database/migrations下打开新创建的迁移文件。|146692|在您的up方法中插入以下内容：|146693|Schema::table('stnk',+function(Blueprint+$table)
++++{
++++++++$table->renameColumn('id',+'id_stnk');
++++});
}|146694|在你的down方法中：|146695|++++Schema::table('stnk',+function(Blueprint+$table)
++++{
++++++++$table->renameColumn('id_stnk',+'id);
++++});
}|146696|然后在命令行中输入|146697|php+artisan+migrate|146698|那就是哇啦！您刚刚将id重命名为id_stnk。顺便说一句，你可以使用|146699|php+artisan+migrate:rollback|146700|要撤消更改，请执行以下操作。祝你好运|146701|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|17|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|19|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1B|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|1D|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1F|8|@]|9|@]|A|$G|H]]|$1|10|3|11|5|6|7|1G|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|13|$]]

first thing you want to do is to create your migration file.

Type in your command line

<pre><code>php artisan make:migration rename_stk_column --table="YOUR TABLE" --create
</code></pre>

After creating the file. Open the new created migration file in your app folder under database/migrations.

In your up method insert this:

<pre><code>Schema::table('stnk', function(Blueprint $table)
 {
 $table-&gt;renameColumn('id', 'id_stnk');
 });
}
</code></pre>

and in your down method:

<pre><code> Schema::table('stnk', function(Blueprint $table)
 {
 $table-&gt;renameColumn('id_stnk', 'id);
 });
}
</code></pre>

then in your command line just type

<pre><code>php artisan migrate
</code></pre>

Then wollah! you have just renamed id to id_stnk. 
BTW you can use

<pre><code>php artisan migrate:rollback
</code></pre>

to undo the changes. Goodluck

blocks|key|144448|text|把我的0.02美元扔在这里，因为没有一个答案有效，但确实让我走上了正确的道路。发生的情况是，之前的外部约束抛出了错误。想想看，这是显而易见的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|144449|因此，在新迁移up方法中，首先删除原始约束，重命名该列，然后使用新的列名重新添加该约束。在down方法中，您做了完全相反的操作，这样它就会返回到sold设置。|offset|length|style|CODE|144450|/**
+*+Run+the+migrations.
+*
+*+@return+void
+*/
public+function+up()
{
++++Schema::table('proxy4s',+function+(Blueprint+$table)+{
++++++++//+Drop+it
++++++++$table->dropForeign(['server_id']);

++++++++//+Rename
++++++++$table->renameColumn('server_id',+'linux_server_id');

++++++++//+Add+it
++++++++$table->foreign('linux_server_id')->references('id')->on('linux_servers');
++++});
}

/**
+*+Reverse+the+migrations.
+*
+*+@return+void
+*/
public+function+down()
{
++++Schema::table('proxy4s',+function+(Blueprint+$table)+{
++++++++//+Drop+it
++++++++$table->dropForeign(['linux_server_id']);

++++++++//+Rename
++++++++$table->renameColumn('linux_server_id',+'server_id');

++++++++//+Add+it
++++++++$table->foreign('server_id')->references('id')->on('linux_servers');
++++});
}|code-block|syntax|javascript|144451|希望这能为将来的人节省一些时间！|144452|entityMap^0|0|7|2|19|4|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]|$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

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 <code>up</code> method, first drop that original constraint, rename the column, then add the constraint again with the new column name. In the <code>down</code> method, you do the exact opposite so that it's back to the sold setting.

<pre><code>/**
 * 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');
 });
}
</code></pre>

Hope this saves someone some time in the future!

blocks|key|2723950|text|重命名列(Laravel+5.x)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2723951|要重命名列，可以使用架构构建器上的renameColumn方法。*在重命名列之前，请确保将依赖项添加到composer.json文件中。*|2723952|或者您可以简单地使用composer来请求包...|2723953|composer+require+doctrine/dbal|code-block|syntax|javascript|2723954|来源：+https://laravel.com/docs/5.0/schema#renaming-columns|offset|length|style|BOLD|2723955|注意:使用make:migration而不是迁移:make+5.x|2723956|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/5.0/schema#renaming-columns^0|0|0|0|0|0|3|4|1G|0|0|5|E|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|13|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|14|8|@$M|15|N|16|O|P]]|9|@$M|17|N|18|1|19]]|A|$]]|$1|Q|3|R|5|6|7|1A|8|@$M|1B|N|1C|O|P]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

<h1>Renaming Columns (Laravel 5.x)</h1>

To rename a column, you may use the renameColumn method on the Schema builder. *Before renaming a column, be sure to add the <a href="https://packagist.org/packages/doctrine/dbal" rel="noreferrer">doctrine/dbal</a> dependency to your composer.json file.*

Or you can simply required the package using composer...

<pre><code>composer require doctrine/dbal
</code></pre>

Source: <a href="https://laravel.com/docs/5.0/schema#renaming-columns" rel="noreferrer">https://laravel.com/docs/5.0/schema#renaming-columns</a>

Note: Use make:migration and not migrate:make for Laravel 5.x

blocks|key|146728|text|执行以下步骤，分别用于重命名列迁移文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|146729|1-在你的项目中有没有Doctrine/dbal库。如果您没有先运行该命令|offset|length|style|BOLD|146730|composer+require+doctrine/dbal|code-block|syntax|javascript|146731|2-为更新旧迁移文件创建更新迁移文件。警告(需要具有相同的名称)|146732|php+artisan+make:migration+update_oldFileName_table|146733|例如，我的旧迁移文件名:+create_users_table更新文件名应为:+update_users_table|146734|3-+update_oldNameFile_table.php|146735|Schema::table('users',+function+(Blueprint+$table)+{
$table->renameColumn('from',+'to');
});|146736|‘'from’我的旧列名和'to‘我的新列名|146737|4-最终运行迁移命令|146738|php+artisan+migrate|146739|来源链接：+laravel+document|146740|NOT:此功能支持从laravel+5.x到8.x版本。|146741|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/8.x/migrations#modifying-columns^0|0|0|2|0|0|0|2|0|0|0|0|2|0|0|0|0|2|0|0|0|5|6|G|0|0|0|4|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@$D|1G|E|1H|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1I|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1J|8|@$D|1K|E|1L|F|G]]|9|@]|A|$]]|$1|O|3|P|5|J|7|1M|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|1N|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1O|8|@$D|1P|E|1Q|F|G]]|9|@]|A|$]]|$1|U|3|V|5|J|7|1R|8|@]|9|@]|A|$K|L]]|$1|W|3|X|5|6|7|1S|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1T|8|@$D|1U|E|1V|F|G]]|9|@]|A|$]]|$1|10|3|11|5|J|7|1W|8|@]|9|@]|A|$K|L]]|$1|12|3|13|5|6|7|1X|8|@$D|1Y|E|1Z|F|G]]|9|@$D|20|E|21|1|22]]|A|$]]|$1|14|3|15|5|6|7|23|8|@$D|24|E|25|F|G]]|9|@]|A|$]]|$1|16|3|-4|5|6|7|26|8|@]|9|@]|A|$]]]|17|$18|$5|19|1A|1B|A|$1C|1D]]]]

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
<pre><code>composer require doctrine/dbal
</code></pre>
2- create update migration file for update old migration file.
Warning (need to have the same name)
<pre><code>php artisan make:migration update_oldFileName_table
</code></pre>
for example my old migration file name: create_users_table
update file name should : update_users_table
3- update_oldNameFile_table.php
<pre><code>Schema::table('users', function (Blueprint $table) {
$table-&gt;renameColumn('from', 'to');
});
</code></pre>
'from' my old column name and 'to' my new column name
4- Finally run the migrate command
<pre><code>php artisan migrate
</code></pre>
Source link: <a href="https://laravel.com/docs/8.x/migrations#modifying-columns" rel="nofollow noreferrer">laravel document</a>
NOT: This feature supports from laravel 5.x to 8.x version.

blocks|key|2724004|text|我知道这是一个老问题，但我最近在Laravel+7应用程序中遇到了同样的问题。为了使重命名列起作用，我使用了this+answer中的一个技巧，而不是composer+require+doctrine/dbal，我发出了composer+require+doctrine/dbal:%5E2.12.1，因为最新版本的doctrine/dbal仍然抛出错误。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|2724005|请记住，如果您已经使用了更高版本，则此答案可能不适合您。|2724006|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/65014592/2540699^0|G|9|23|U|32|12|1I|4|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|D]|$9|V|A|W|B|D]]|E|@$9|X|A|Y|1|Z]]|F|$]]|$1|G|3|H|5|6|7|10|8|@]|E|@]|F|$]]|$1|I|3|-4|5|6|7|11|8|@]|E|@]|F|$]]]|J|$K|$5|L|M|N|F|$O|P]]]]

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 <a href="https://stackoverflow.com/a/65014592/2540699">this</a> answer where instead of <code>composer require doctrine/dbal</code> I have issued <code>composer require doctrine/dbal:^2.12.1</code> 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.

blocks|key|148258|text|要重命名列，可以使用架构构建器上的renameColumn方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|148259|Schema::table('users',+function+(Blueprint+$table)+{
++++$table->renameColumn('from',+'to');
});|code-block|syntax|javascript|148260|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To rename a column, you may use the renameColumn method on the Schema builder.
<pre><code>Schema::table('users', function (Blueprint $table) {
 $table-&gt;renameColumn('from', 'to');
});

</code></pre>

I have columns as mentioned bellow: 

<pre><code>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');
 });

}
</code></pre>

I have made seeder to stnk table

Now I want to rename <code>id</code> to <code>id_stnk</code>. 
I've added a "doctrine / dbal" in the "composer" and do a <code>composer update</code>. 

I've made migration <code>php artisan migration:make rename_column</code>. 
Then I've added new method to rename_column:

<pre><code>Schema::table('stnk', function(Blueprint $table)
{
 $table-&gt;renameColumn('id', 'id_stnk');

});
</code></pre>

And then I've tried to run command <code>php artisan migrate</code> but I got error as mentioned bellow:

<pre><code>[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)
</code></pre>

How can I rename column in laravel using migration?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有下面提到的专栏：public function up(){    Schema::create('stnk', function(Blueprint $table)    {        $table->increments('id');        $table->string('no_reg', 50)->...

问如何使用迁移重命名laravel中的列？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用迁移重命名laravel中的列？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用迁移重命名laravel中的列？
EN