本文为【实例讲解"MySQL"在记录不存在时的插入】的汉字拼音对照版显示拼音
MySQL在zai记ji录lu不bu存cun在zai时shi的de插cha入ru:
示shi例li:插cha入ru多duo条tiao记ji录lu
假jia设she有you一yi个ge主zhu键jian为wei client_id 的de clients 表biao,可ke以yi使shi用yong下xia面mian的de语yu句ju:
INSERT INTO clients
(client_id, client_name, client_type)
SELECT supplier_id, supplier_name, 'advertising'
FROM suppliers
WHERE not exists (select * from clients
where clients.client_id = suppliers.supplier_id);
示shi例li:插cha入ru单dan条tiao记ji录lu
INSERT INTO clients
(client_id, client_name, client_type)
SELECT 10345, 'IBM', 'advertising'
FROM dual
WHERE not exists (select * from clients
where clients.client_id = 10345);
使shi用yong dual 做zuo表biao名ming可ke以yi让rang你ni在zai select 语yu句ju后hou面mian直zhi接jie跟gen上shang要yao插cha入ru字zi段duan的de值zhi,即ji使shi这zhe些xie值zhi还huan不bu存cun在zai当dang前qian表biao中zhong。
【原文】