On Tue, 21 Feb 2006, Patrick Duda wrote: > Why, when I create a table as follows: > > mysql> create table requestid ( request_id int not null default 1, > constraint requestid_innodb_pk_cons primary key(request_id) ) ENGINE=InnoDB; > Query OK, 0 rows affected (0.02 sec)
Defines the properties of an empty table.... The request id field for an inserted object will default to one if not supplied. But the object must be supplied. Hugh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]