Mysql 记录不存在时写入数据库

INSERT INTO `card`(`msisdn`, `iccid`) select '14410460', '898604A41921C1312999' from DUAL where not EXISTS (select * from card where msisdn= '14410460');

其中DUAL为系统自带的虚拟表