Page 1 of 1

mysql: inserts even if the field declared not null

Posted: Thu Jul 14, 2005 3:47 am
by raghavan20
In my database, I have almost all the important fields declared not null but for some unknown reason the database allows to update empty fields into the db.

I have never seen that happen in MSAccess or Oracle!!!

Could any of you tell me why? what to do with that?

Posted: Thu Jul 14, 2005 5:03 am
by timvw
I can give you only one advice: Use a real SQL DBMS like PostgreSQL...



With MySQL you simply don't have data integrity :( For example, MyQSL accepts 9999-99-99 as a date... and stores it as 0000-00-00.. Imho, it should refuse to accept the date...