INSERT INTO test1(a_id,b_id,c,d) SELECT 1,1,'5a','5d' FROM test1 m WHERE NOT EXISTS( SELECT 1 FROM test1 m WHERE a_id=1 AND m.b_id=1) LIMIT 1;
调试方法:可以先运行后面的select语句,看是否有结果数据,和实际情况对照后调整where条件
CREATE TABLE `test1` (
`a_id` bigint(10) DEFAULT NULL,
`b_id` bigint(10) DEFAULT NULL,
`c` varchar(10) DEFAULT NULL,
`d` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;