Inserting a NULL into a NOT NULL column used to automatically get the DEFAULT value. I realize that it was non-portable, non-standard behavior, but the code relies on it. How do I get this behavior in the 4.0.x server?
mysql> CREATE TABLE t (a INT NOT NULL DEFAULT 0); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t (a) VALUES (NULL); ERROR 1048: Column 'a' cannot be null -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
