Mailing List Archive


Back to the month index Back to the list index
Chris Lambrou (chrislambrou@internetmci.com)
Tue, 22 Apr 1997 19:30:10 -0400 

Date: Tue, 22 Apr 1997 19:30:10 -0400
From: Chris Lambrou <chrislambrou@internetmci.com>
Subject: Re: [mSQL] Automatic field identifier?
Message-Id: <01II0MZ4CFI68Y570J@MAIL-CLUSTER.PCY.MCI.NET>

Oscar,

Sounds like you need a counter field which is not available in mSQL. You
could simulate a counter field by maintaining a counter table. Before you
insert a new record, you hit the table, get the counter value and you
update the counter field by one.

* Chris
* CGL Internet Services, Inc.

----------
> From: Oscar Santos <santos@xures.ei.uvigo.es>
> To: msql-list@bunyip.com
> Subject: [mSQL] Automatic field identifier?
> Date: Tuesday, April 22, 1997 8:48 PM
>
> Hello friends!
>
> I4m new in mSQL and of course i4ve a question for you:
>
> When I insert a record in my database, Is there a way that
> msql automatically gives him a unique identifier?
>
> example
>
> Table : people
>
> create table people( IDpeople int, name char(50))
>
> .( I don4t know?).
>
> insert into people values ( $what, 'Oscar Santos')
>
> Note I use a database whith some tables with relationships between them.
>
>
>
> Thanks and sorry my English.
>
> Saludos.
>
>
> Oscar Santos
> santos@xures.ei.uvigo.es
>
--------------------------------------------------------------------------
> To remove yourself from the Mini SQL mailing list send a message
containing
> "unsubscribe" to > "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
> "info msql-list" to majordomo@bunyip.com for info on monthly archives of
> the list. For more help, mail owner-msql-list@bunyip.com NOT the
msql-list!

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!