vendredi 29 janvier 2016

CREATE VIEW with IF and ERROR

CREATE VIEW nextClass AS
SELECT date,id
FROM class
WHERE date >= CURDATE()
AND IF (
    date < CURDATE(),
    ERROR_MESSAGE('You cannot update previous classs'),
    CLOSE()
    )

Can someone help with the CREATE VIEW statement in SQL. I need to show all future classes and reject attempts to update previous classes. I have a syntax error in this code.

Aucun commentaire:

Enregistrer un commentaire