By that I mean if the row is updated and the field value is still null, the update for the row is rejected and an error is produced.
The "NOT NULL" clause in the table definition simply converts NULL values to '' or zero for string and numeric fields. This only makes things worse because now it is harder to spot invalid data because the zeroes and '' blends in with valid data.
So I need the update to fail so I can keep invalid data (NULL's) out of the table. Any idea on how to do this? TIA
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
