logo       

Re: automatic generation of primary keys?: msg#00186

db.sqlite.general

Subject: Re: automatic generation of primary keys?

--- In sqlite-F5Bj5G+ccuY@xxxxxxxxxxxxxxxx, "to0ni" <tgoedeme@xxxx> wrote:
> Does anyone know if there exists a mechanism to automatically generate
> the unique primary key while inserting a row in a database?

If the table has an INTEGER PRIMARY KEY, just insert NULL for that
column and it will automatically generate the key.

Jim Lyon


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/CBxunD/vN2EAA/xGHJAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise