i make InnoDB tables in mysql.
I notice that it is possible to add rows where the foreign key is null!!
should this be possible?
however it is not possible to add rows with a foreeign key other then null that does not match any entri in the dad-table.
do u have to type not null so that u cant add entries that has no corresponding dad-entri in the dad-table?
i thought "foreign key references bla bla" should do this for u?
thank you very much