If the master is InnoDB, must slaves also be InnoDB, or could they be
MyISAM? (Assuming no foreign keys are set to CASCADE.) -John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
Just leave the NOT NULL column out when inserting and it will
get set to its default.
It's not just one sql statement.