Web lists-archives.com

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