sql - Grails数据库迁移-如何删除特定行？

Question

我必须进行手动迁移才能删除表中称为“类型”的特定行。

该行在值列中具有值“ super ”。我应该如何为此写changeSet？

我试过了:

databaseChangeLog = {

changeSet(author: "sara (generated)", id: "1432343423-8") {
   delete(tableName: "Types") {
        where(value: "Super")
    }
}

Answer 1

您需要执行sql:
changeSet(author: "you", id: "1437421083434-8") {
sql("DELETE FROM types WHERE value='Super';")
}