1 reply to this topic

[BASHERS33]

Just to show how much I know of the basics of mySQL I don't even remember if it's called strict mode, but I think it is? Anyway what do I need to pay attention to in order to avoid errors in that type of setup when I am not using it myself?

In the past someone had mentionedthat the main thing is that any field which does not have a default value must either always have a value put into it on an insert or it must have a default of NULL. Is this true? And I believe update queries are fine regardless so all I need to pay attention to are the inserts?

[Orjan]

I think fields without values becomes null automatically unless flag "not null" is set, then it won't allow it instead, if I remember correct.