SQL:将值插入外键-SQL:insertvalueintoforeignkey

1  

Use two separate insert statements wrapped in a transaction.

使用封装在事务中的两个独立的insert语句。

To insert an image for an event which already exists, just use the insert statement for the image.

要为已经存在的事件插入图像，只需使用图像的insert语句。

2  

You should INSERT first the event, if Ok, then INSERT the image if it has any. Don't know, how you want to do that, but I think you should check if there is an insert or update that you want.

您应该首先插入事件，如果Ok，则插入图像，如果有的话。不知道该怎么做，但我认为您应该检查是否需要插入或更新。

In both situation you should use a transaction to ensure that you insert all that you want or not at all. (Event and Image in this case).

在这两种情况下，都应该使用事务来确保插入所需的所有内容。事件和图像。

Read something about transaction and isolation level to understand this better.

阅读一些关于事务和隔离级别的内容，以便更好地理解这一点。

1  

Invalid SQL Syntax. There in no way to do it in one instruction in SQL.

无效的SQL语法。在SQL中的一条指令中不可能做到这一点。

Insert in event, then insert in images. Use a transaction like swarFish said if you want to ensure atomicity (ensure that both are successful or no register is inserted).

插入事件，然后插入图像。如果您希望确保原子性(确保两者都成功或不插入寄存器)，请使用swarFish所说的事务。