Re: Autoincremental value

Estimado Mage,

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

M> adburne(at)asocmedrosario(dot)com(dot)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(at)asocmedrosario(dot)com(dot)ar