Hey guys. I have a MySQL question. I have two

Question

Hey guys. I have a MySQL question. I have two

tables: products and images with a one to many relationship (one product, many images). There's a foreign key in the images table referencing the products table primary key.

The problem is that value isn't known until the insert is made so the rows in the images table can't reference the relevant row in products table. (Worse, if the foreign key is set to not null it won't make the insert).

What's a way to circumnavigate this?

Thanks in advance.

0

19.07.2020

2 ответов

22 просмотра

Roy King

For starters i would not recommend using table to store images consider having a folder with your images instead save images in folder then add the folder path to your products table

0

19.10.2021

Thomas · Accepted Answer

Thomas

insert product first then you have the product key, so now you can insert the images

0

19.07.2020

Похожие чаты

Hey guys. I have a MySQL question. I have two

2 ответов

Похожие вопросы