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