mysql-规避重复插入

http://lobert.iteye.com/blog/1604122

 

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);