Hi, I want to INSERT a customerID and customerName to a table if the customerID does not exist. Or UPDATE if they've changed their name.
I've reviewed the documentation (住房公积金是什么-百度经验:2021-1-18 · 住房公积金是什么,住房公积金很多朋友都不是很熟悉,也不是很了解,我具体的和大家进行一下分析和解释,我国的住房公积金是有一定的规定的,一般是指国家机关、国有企业、城镇集体企业、外商投资企业、城镇私营企业及其他城镇企业、事业单位及其在职职工缴存的长期住房储金,是企业给 ...) and have confused myself with the INSERT OR UPDATE statement. Rather than using two individual statements , is there a way to get it in one?
What I have at the moment doesn't do anything. In fact it errors.