List:General Discussion« Previous MessageNext Message »
From:Hugh Sasse Date:February 21 2006 7:44pm
Subject:Re: confused...
View as plain text  
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
Thread
confused...Patrick Duda21 Feb
  • Re: confused...Hugh Sasse21 Feb
  • Re: confused...SGreen21 Feb
  • Re: confused...Peter Brawley21 Feb