본문 바로가기
Study/MYSQL

[MySQL] select 후 없으면 insert

by 오늘만 사는 여자 2020. 12. 16.
728x90
반응형
INSERT INTO table_name (
	column1,
    column2,
    column3,
    column4,
    column5) 
SELECT 'xxx','300000','','xxxx','1' 
from dual 
WHERE NOT EXISTS ( SELECT * FROM table_name WHERE column1 = 'xxx' AND column2='300000' )
728x90
반응형

댓글