mySQL rules different between dev & live sites

[eluser]theshiftexchange[/eluser]
Hi guys,

I've just noticed that when moving my DB to my live site, I got an error which I could not reproduce in my dev environment.

Its turns out my dev environment mySQL server does not 'enforce' not-null rules in the tables, while the live site does.

So now I'm worried about other things that might be different, not to mention the 'null' vs 'notnull' issue.

Any ideas where/how to find out the 'rules' that are enforced for each server?