M250321114459DeleteQimallTown.php 674 B

1234567891011121314151617181920212223242526272829303132333435363738
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * 删除 安徽省下面 寿县 下不属于它的乡镇
  6. * Class M250321114459DeleteQimallTown
  7. */
  8. class M250321114459DeleteQimallTown extends Migration
  9. {
  10. /**
  11. * {@inheritdoc}
  12. */
  13. public function safeUp()
  14. {
  15. try {
  16. $sql = <<<SQL
  17. delete from qimall_town where district_id = 1057 and adcode = 130126
  18. SQL;
  19. $this->execute($sql);
  20. } catch (\Exception $e) {
  21. }
  22. }
  23. /**
  24. * {@inheritdoc}
  25. */
  26. public function safeDown()
  27. {
  28. echo "M250321114459DeleteQimallTown cannot be reverted.\n";
  29. return false;
  30. }
  31. }