Re: find any row with NULL
- Date: Fri, 29 Jul 2016 15:52:18 -0400
- From: "Hal.sz S.ndor" <hsv@xxxxxxxx>
- Subject: Re: find any row with NULL
Now - would searching, saving/storing then removing NULL vs ALLbutNULL
in a simple DB with one table wich has only primary key be sa
What is "removing NULL"? Deleting the record with NULL?
It has no bearing on the primary key, because NULL never is allowed in one.
It seems to me that really you want "NOT NULL" in many of your field
declarations. If some field has no NULLs then "ALTER TABLE ... MODIFY
... ... NOT NULL" will work, but if it has NULLs then (in strict mode)
that will fail unless there is a default value. Are default values of
any use to you?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql