[Skod]

Hello

I'm trying to make an insert statement, that inserts into a table with foreign keys, and if a foreign from another table doesn't exists it creates it and inserts the new ID. It's hard to explain I hope you understand what I mean.
I've seen this piece of SQL somewhere but i can't seem to find it or write it myself, can anyone please help?

Any help will be appreciated.

Sincerely,
Daniel

[modi123_1]

It's nothing more than a multi-part sql procedure using a boolean variable and if statement. Create boolean variable.. have it be set true or false if a select statement querying the foreign key table contains the pertinent data. If it does not exist then do an insert... else just exit the procedure or do what ever you want to do if it exists.

[Skod]

I'm still a bit new to SQL, could you please give an example of what you mean?

[modi123_1]

Alternatively you could read up on the syntax and usage... select statements, user variables, and if-syntax!

https://dev.mysql.co.../en/select.html
https://dev.mysql.co...-variables.html
https://dev.mysql.co...-statement.html