CODEWITHSUNDEEP
mysqlsql
AMAL BENNY
AMAL BENNY

Reputation: 51

How to insert to a table if there exist a value in another table

i have tried this

INSERT into examqst set qno=1, qst="aa" ,qan1="a" , qan2="B", qan3="C", qan4="d", qant="A", qtype=0, examid=1 
WHERE EXISTS (SELECT * FROM examname  where examid=1 and s_id=10);

I want to insert to examqst only if there is a row examid in examname table and s_id in examname have a perticilar value

Upvotes: 0

Views: 45

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 522719

You could an INSERT INTO...SELECT:

INSERT INTO examqst (qno, qst, qan1, qan2, qan3, qan4, qant, qtype, examid)
SELECT 1, 'aa', 'a', 'B', 'C', 'd', 'A', 0, 1 
WHERE EXISTS (SELECT 1 FROM examname WHERE examid = 1 AND s_id = 10);

Upvotes: 1

Related Questions