Incrementing Primary Key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear List -

Thanks for all your excellent help.

I am setting up a database for medical research, which will be conducted at various sites. The sites will be identified by a letter {A,B,C ....}. The medical record number [primary key] will start at 1001 and increment by one(1) for each patient at each site; ie, A 1001, A1002, B1001, B1002 ...... How do I do this?

Do I need a separate database for each site?

Ethan



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux