[SQL] INSERT한 칼럼의 pk, 변수선언

INSERT INTO quiz (music_pk, writer) SELECT pk, writer FROM music WHERE music.title="Havana";

SELECT @quiz_pk := LAST_INSERT_ID();

INSERT INTO choice (quiz_pk, choice_text, truth) VALUES (@quiz_pk, "문제1", 1);

INSERT INTO choice (quiz_pk, choice_text, truth) VALUES (@quiz_pk, "문제2", 1);

INSERT INTO choice (quiz_pk, choice_text, truth) VALUES (@quiz_pk, "문제3", 1);