Re: Autoincremental value

Estimado Mage,

Con fecha viernes 13 de agosto de 2004, 16.54.09, escribió:

M> adburne@asocmedrosario.com.ar wrote:

>>when insert rows:
>>
>>insert into table1 (field1) values (1);
>>insert into table1 (field1) values (1);
>>insert into table1 (field1) values (2);
>>
>>and then select * from table1, you get:
>>field1| field2
>>------+-------
>>  1   |  1
>>  1   |  2
>>  2   |  1
>>------+-------
>>
>>
M> Do you mean:


M>  field1| field2
M>  ------+-------
M>    1   |  1
M>    1   |  2
M>    2   |  3
M>  ------+-------

M> You need the serial type.

M>           Mage


Thnx to everybody for your answers; you put the finger on the key =), in
mysql you can create a mixed autoincremental on 2 fields, then the first
act as key and the second field is autoincremental based on the first
field. Like I wrote in the prev msg.

field1| field2
------+-------
  1   |  1
  1   |  2
  2   |  1
------+-------

I was reading about serial type but I didn't find anything to do this
like mysql.

--
Saludos,
 adburne
 mailto:adburne@asocmedrosario.com.ar