MySQL: Insert if foreign key exists?

You could change to insert the result of a select, so something like: INSERT INTO test (id, value) SELECT foobar. Id, 20 FROM foobar WHERE id = 10.

Have to add limit 1, otherwise each insert could be multiple rows. – MJB Jun 25 '10 at 12:05 @MJB I'm assuming that id is the primary key on foobar, per the OP, so the LIMIT shouldn't be needed. – Rowland Shaw Jun 25 '10 at 12:10 If I do it like that, it's only possible to insert data into "test", which is already in "foobar", right?

But I have new data to add, which comes from the excel sheet. Can I somehow adjust this, so I can add new data to it? – user375700 Jun 25 '10 at 12:12 I mis-read.

I think you are right, and I retract my comment. – MJB Jun 25 '10 at 13:45 @snootles Have you the information to create the record in foobar? If so you could instead pre-create the values, perhaps using a query along the lines of INSERT INTO foobar (id,...) SELECT 10, ... FROM test LEFT JOIN foobar ON test.Id = foobar.

Id WHERE foobar. Id IS NULL – Rowland Shaw Jun 25 '10 at 18:05.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.