View Single Post
Old 07-29-2006, 09:29 AM   #2 (permalink)
DJMaze
Senior Contributor
 
DJMaze's Avatar
 
Join Date: Mar 2005
Posts: 741
DJMaze is on a distinguished road
Your db table records need a key/id field for easy access.

MySQL: AUTO_INCREMENT
PostgreSQL: SERIAL or see below
Relational SQL: 'before insert' trigger that calls the gen_id() procedure with the appropiate generator.
DJMaze is offline   Reply With Quote