Re: SQl to MYSQL

[Peter Brawley]

Each If... construct is missing three things ...

(i) IF >.. THEN --- THEN is required

(ii) statements require terminating semicolons

(iii) the IF construct must close with END IF;

Thus ...

if exists (Select * from VIAGENS where ID_VIATURA = pID_VIATURA AND  pDATAHORAINICIO between DATAHORAINICIO and DATAHORAFINAL ) THEN
  set DisponibilidadeViatura = 0;
else
  set DisponibilidadeViatura = 1;
END IF;

Likewise for the other IF constructs.



Edited 1 time(s). Last edit at 06/30/2018 08:52PM by Peter Brawley.