Hi,
imagien a table like:
CREATE TABLE test(col1 INT DEFAULT SERIAL, PRIMARY KEY (col1))
The statement
INSERT INTO test(col1) VALUES(0)
uses the default (a serial value) instead of the value supplied in the insert. As far as i know, the default must only be used, if the supplied value is NULL, and since 0 is not NULL, the default shouldn't be used.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
