[MySql] INSERT + UPDATE

INSERT + UPDATE

INSERT를 실행하는데 값을 비교하여 변경사항이 있는 경우 UPDATE를 실행

INSERT into tbl (column1, column2, ...) VALUES(value1, value2, ...) ON DUPLICATE KEY UPDATE column1='value1', column2='value2', ...;

$q = "INSERT INTO $bbs(no, dept, name, grade, request, content, state, succ_date) 

VALUES ('$no', '$dept', '$name', '$grade', '$request', '$content', '$state', '$succ_date')

ON DUPLICATE KEY UPDATE 

dept='$dept', name='$name', grade='$grade', request='$request', content='$content', state='$state', succ_date='$succ_date'";

$result = $mysqli->query($q);