Question

我可以说明如何在变化中收回Sql习俗。任何想法?

我愿这样做:

<changeSet author="Charlie White" id="15" runAlways="false" runOnChange="false" failOnError="true">
<sql> 
INSERT INTO `XXXX` (`CONFIG_ID`,`NAME`,`VALUE`) VALUES YYYY;
</sql>
<rollback>
     DELETE FROM  XXXX" WHERE  YYYY";
</rollback>

可能的话:

<changeSet author="Charlie White" id="15" runAlways="false" runOnChange="false" failOnError="true">
<sql> 
INSERT INTO `XXXX` (`CONFIG_ID`,`NAME`,`VALUE`) VALUES YYYY;
</sql>
<rollback> <sql>
     DELETE FROM  XXXX" WHERE  YYYY";
</sql></rollback>

得到帮助。

Answer 1

首先应当:

<changeSet author="Charlie White" id="15" runAlways="false" runOnChange="false" failOnError="true">
    <sql> 
    INSERT INTO `XXXX` (`CONFIG_ID`,`NAME`,`VALUE`) VALUES YYYY;
    </sql>
    <rollback>
     DELETE FROM  XXXX" WHERE  YYYY";
   </rollback>
</changeSet>

友情链接