Re: auto Incerment

2002-09-18 Thread vinita vigine Murugiah
HI Paul Thank you very much!!! yes it works when I have PRIMARY KEY (SoftwareId, id) but didn't work for KEY(SoftwareId, id), since this allows to have multiple entries on the keys, I think vinita Paul DuBois wrote: > At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote: > >> HI >> >

Re: auto Incerment

2002-09-18 Thread Paul DuBois
At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote: > HI > >I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 > >This is the definition of table software_machineOSs >++--+--++-++ >| Field | Type | Null

Re: auto Incerment

2002-09-18 Thread vinita vigine Murugiah
Hi Well... I tried all the methodes, tried inserting with out the id, with NULL id & with 0 as id. No of them seems working :-( Any other ideas?? Thanks you Arjen van der Weijden wrote: >Leave out the id column in your insert-statement > > > >

Re: auto Incerment

2002-09-17 Thread vinita vigine Murugiah
> HI > > I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 > > This is the definition of table software_machineOSs > ++--+--++-++ > | Field | Type | Null | Key | Default | > Extra