Re: confused...

[Hugh Sasse]

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