HEROJOON 블로그(히로블)

Mysql에서 변수 사용하기 @변수명 = 값; 예시 @title = 'hello'; @content = 'happy christmas!!'; INSERT INTO board (id, title, content, user, create_dt) VALUES (NULL, @title, @content, 'herojoon', NOW()); SET @boardId = SELECT LAST_INSERT_ID(); INSERT INTO reply (id, board_id, reply) VALUES (NULL, @boardId, 'first reply');