希望对大家能有所帮助
在mysql下:
<!-- 创建外键 -->
<statement id="createFK" parameterClass="parameterBean" >
<![CDATA[
ALTER TABLE famm_groups_users ADD FOREIGN KEY(mainUserID) REFERENCES $mtableName$($muserPK$) ON UPDATE CASCADE ON DELETE CASCADE
]]>
</statement>
在oracle下:(没有级联更新,不能使用on delete cascade)
<!-- 创建外键 -->
<statement id="createFK" parameterClass="parameterBean" >
<![CDATA[
ALTER TABLE famm_groups_users ADD FOREIGN KEY(mainUserID) REFERENCES $mtableName$($muserPK$) ON UPDATE CASCADE ]]>
</statement>
在mysql下:
<!-- 创建外键 -->
<statement id="createFK" parameterClass="parameterBean" >
<![CDATA[
ALTER TABLE famm_groups_users ADD FOREIGN KEY(mainUserID) REFERENCES $mtableName$($muserPK$) ON UPDATE CASCADE ON DELETE CASCADE
]]>
</statement>
在oracle下:(没有级联更新,不能使用on delete cascade)
<!-- 创建外键 -->
<statement id="createFK" parameterClass="parameterBean" >
<![CDATA[
ALTER TABLE famm_groups_users ADD FOREIGN KEY(mainUserID) REFERENCES $mtableName$($muserPK$) ON UPDATE CASCADE ]]>
</statement>