[Year 12 IT Apps] SQL Constraints

[Baas, Benjamin B]

Hi all,

Has anyone taught SQL before for databases and if yes what did you do for constraints (validation)?

Currently the standard set up for phpMyAdmin and MySQL ignores check constraints. I can get around it using triggers, but having check constraints when creating tables is so much easier.

Cheers,

Ben.

Benjamin Baas
[Description: cid:image001.png at 01C9CA67.50F474D0] Alkira Secondary College
*   Nurture Ave, Cranbourne North | PO Box 4314, Narre Warren South 3805
'   +61 3 5991 3500      6 +61 3 5991 3599     * www.alkirasecondarycollege.com.au<http://www.alkirasecondarycollege.com.au/>
Alkira Secondary College believes in Personalised learning for all, and  Respect for the individual


Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20150423/8b82c5df/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1700 bytes
Desc: image001.png
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20150423/8b82c5df/image001.png