MERGE INTO meber_t T1
if(user_id=='alseom')
USING DUAL ON (T1.user_id='alseom')
WHEN MATCHED THEN
UPDATE
SET email='alseom@alseom.co.kr', mobile='016-xxx-xxxx'
WHEN NOT MATCHED THEN
INSERT (email, mobile)
VALUES ('alseom@alseom.co.kr', '016-xxx-xxxx')
update email, mobile
else
insert email, mobile
View Comments,
Trackbacks
댓글을 달아 주세요