如何修改mysql表的字段类型
通过命令创建migration文件
内容如下
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\DB;
class AlterTableHlUserListAddTenantId extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('user_list',function (Blueprint $table) {
$table->integer('admin_id')->after('id')->comment('admin_id');
DB::statement("ALTER TABLE user_list MODIFY mobile int default 0 NOT NULL");
$table->renamecolumn('mobile','user_id');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('user_list', function(Blueprint $table)
{
$table->dropColumn('admin_id');
DB::statement("ALTER TABLE hl_user_list MODIFY user_id varchar(20) default '' NOT NULL COMMENT '手机号'");
$table->renameColumn('user_id','mobile');
});
}
}
执行php artisan migrate即可完成字段的类型修改
如有问题,可以QQ搜索群1028468525加入群聊,欢迎一起研究技术
转载请注明:laravel 通过migrate迁移文件改变数据表某字段类型 出自老鄢博客 | 欢迎分享