Who understands SQL Please Help!!

[d4ve86]

LONG uni work,

create a table t6 but add a constraint according to which t6 cannot have more than 5 rows?
done the table and cant do the constraint

CREATE RULE five_rows AS
ON INSERT TO T6
WHERE customer_number > 5
DO ;

is this right or am i going wrong!

Please help me cheers!!

 

[sh33n]

http://dev.mysql.com/doc/

Haven't done any in a while but the above you should help.

 

[d4ve86]

cheers