MySQL Conditional INSERT

Question

I want to do a conditional insert with MySQL. I have 2 tables (Car and CarType).

The Car table got a coloumn called typeId, which points to an entry in the CarType table.

I only want to insert a row in the Car table if the given typeId exists in the CarType table.

I've tried some Googling, and tried a couple of solutions. Here is what I found
(but it does not work):

INSERT INTO Car (title, licensePlate, carType 
SELECT 'Ford Transit', 'SV 32 654', '13' 
FROM DUAL 
    WHERE EXISTS (SELECT typeId FROM CarType WHERE typeId = 13)

dup : stackoverflow.com/questions/913841/mysql-conditional-insert — Haim Evgi
– Haim Evgi, Commented Dec 5, 2010 at 12:30
I've seen that and tried that (as you would have known if you actually saw my code). It doesn't work. Not for me atleast. — Nilks
– Nilks, Commented Dec 5, 2010 at 13:03

ajreal · Accepted Answer · 2010-12-05 14:03:57Z

3

I think you misleading by the example, it can be as simple as this :

INSERT INTO Car (title, licensePlate, carType) 
  SELECT 'Ford Transit', 'SV 32 654', '13' 
  FROM CarType WHERE typeId=13;

answered Dec 5, 2010 at 14:03

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Conditional INSERT

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related