why do not you mark me wrong and do not insert me?

0
    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
    
asked by Carlos Enrique Gil Gil 30.05.2018 в 00:36
source

0 answers