INSERT INTO spartodo_rh.tblVacantesPostuladas
(idVacante,idSolicitudEmpleo,estado,fechaRegistro,fechaModificacion)
SELECT * FROM (SELECT '1', '4','Postulada','2018-05-29
17:28:48','2018-05-29 17:28:49') AS tmp
WHERE NOT EXISTS (SELECT idSolicitudEmpleo FROM
spartodo_rh.tblVacantesPostuladas WHERE idSolicitudEmpleo = '2') LIMIT 1;
is what I have in the table is a record nothing more
idVacantePostulada 1
idVacante 1
idSolicitudEmpleo 2
estado Postulada
fechaRegistro 2018-04-12 16:41:00
fechaModificacion 2018-04-12 16:41:00