qimall/console/migrations/M230418153713UpdateQimallTown.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M230418153713UpdateQimallTown
 */
class M230418153713UpdateQimallTown extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql="DELETE FROM `qimall_town` WHERE `district_id` = 1968;
INSERT INTO `qimall_town`(`district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES 
(1968, 230404, '南山街道', 1594556772, 1594556772),
(1968, 230404, '南头街道', 1594556772, 1594556772),
(1968, 230404, '沙河街道', 1594556772, 1594556772),
(1968, 230404, '蛇口街道', 1594556772, 1594556772),
(1968, 230404, '桃园街道', 1594556772, 1594556772),
(1968, 230404, '西丽街道', 1594556772, 1594556772),
(1968, 230404, '粤海街道', 1594556772, 1594556772),
(1968, 230404, '招商街道', 1594556772, 1594556772);";
            $this->execute($sql);
        }catch (\Exception $e){

        }

    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M230418153713UpdateQimallTown cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M230418153713UpdateQimallTown cannot be reverted.\n";

        return false;
    }
    */
}