如何在表中插入带有外键的行?
我有一个表，它本身有外键.列 parentid 是外键，它不能为 NULL.
I have table that has foreign key for itself. Column parentid is foreign key and it cannot be NULL.
如果我这样做INSERT INTO mytable(name) VALUES('name')，那么它说不能将NULL插入parentid.但是，如果还没有插入行，我可以为它设置什么值?！
if I doINSERT INTO mytable(name) VALUES('name'), so it says that can't insert NULL to parentid. BUT, what value I can set to it if no row was inserted yet?!
如何编写向该表添加行的脚本?
How I can write script that will add row to this table?
谢谢
推荐答案
一个技巧:有一个带有虚拟键的虚拟行，比如 99999.将它作为 FK 插入，然后将 FK 更改为其实际值.并在交易中完成.
A trick: Have a dummy row with a dummy key, say 99999. Insert with this as the FK, and then change the FK to its real value. And do it in a transaction.
相关文章