I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement:
- I want to create a view which restricts staff user access to a specific table between working hours of 13:00 - 14:00.
I have been told that this can be implemented via the sysdate function. Any ideas on how I would do this?
All help is well appreciated!
March 26, 2012 8:58 PM
March 27, 2012 12:44 PM