yii2 数据迁移

migrate 主要提供了个用来生成迁移代码的工具，变更的sql写到对应的迁移文件里头

D:\data\www\yiiadmin>yii migrate/create init Yii Migration Tool (based on Yii v2.0.13.1)

Create new migration 'D:\data\www\yiiadmin\console/migrations\m180920_025653_ini t.php'? (yes|no) [no]:yes New migration created successfully.

执行所有迁移 yii migrate 指定某一个迁移 yii migrate/to m180920_025653_init

还原迁移 yii migrate/down # revert the most recently applied migration 还原最近一次提交的迁移 yii migrate/down 3 # revert the most 3 recently applied migrations 还原最近三次提交的迁移

迁移某一个库 yii migrate --db=db2

例子 public function up() { sql = <<<SQL ALTER TABLE {{%meet_info}} ADD INDEX ( `status` , `start_time` , `meet_stop_status` ); SQL; return this->execute($sql); }

public function down()
{
    echo "m160223_082031_alter_sns_meet_info_add_index cannot be reverted.\n";
    return false;
}

————————————————

                        版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
                    

原文链接：blog.csdn.net/qq_24700495…