Possible to make foreign key auto update?
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?
image table(stored all the article images):
id article_id(foreign key) name
1 1 xyz.jpg