Possible to make foreign key auto update?

Databases
1

Hi guys,
The scenario:
I can submit new article and upload picture for that article.
So lets say i submitted a new article with an image. Base on the table below, my new article_id will be 2. Then problem is how the foreign key in image table auto update the article_id = 2. So that the image name auto matches the article_id i newly submitted. How do i do that?

articles table:
article_id content
1              xxx

image table(stored all the article images):
id    article_id(foreign key)     name
1            1                         xyz.jpg
2

You normally don’t change id keys values.

PK/FK are not meant to be changed. That’s the whole idea about id keys: values that say nothing about the data, so they should not change.

But if you have to, you could rely on ON triggers. And triggers have a history that doesn’t recommend them for this job at all, keeping together the data integrity.

3

you use LAST_INSERT_ID to get the value inserted in the article table and use that to insert into the images table.

4

^ Right you are. I misread what the OP was asking. Sorry.

I don’t use or recommend LAST_INSERT_ID myself, but that’s another story altogether.

5

BIG THANKS to you. I solved my problem tyty! :slight_smile:

6