I have the following syntax
DELIMITER $
CREATE TRIGGER TabelaInterm_BI BEFORE INSERT
ON Tabela_Intermediara FOR EACH ROW BEGIN
INSERT INTO Vizite
(Data_Ora, Id_Medic, Id_Pacient, Id_Cabinet) VALUES
(NEW.Data_Ora, New.Id_Medic, New.Id_Pacient, New.Id_Cabinet,
(SELECT
STR_TO_DATE(CONCAT(DataVizita,' ', OraIntrare), '%Y-%m-%d %H:%i:%s'),
(SELECT Id FROM Medici WHERE Nume=NumeMedic AND Prenume=PrenumeMedic),
(SELECT Id FROM Pacienti WHERE Nume=NumePacient AND Prenume=PrenumePacient),
(SELECT Id FROM Cabinete WHERE Denumire=Cabinet)
END $
DELIMITER ;
It gives me the error
#1064, and at line 12 where END $ is, it says 'Syntax error:missing 'closing paranthesis'! enter image description here
Aucun commentaire:
Enregistrer un commentaire