The database holds records, currenlty there is a new database for each record, so each record for each project starts with a id and increments.
I want to create a sql database that will hold all records for all projects, so I'd like to have a primary key -
xxx/xxxxx
The first three digits would be the project ID, the following 5 digits would be the records unique number.
Is it possilbe to create a field, that I can enter the first three digits, while the following 5 auto increment?
The result would be that all projects would still have records starting from 1, and auto incrementing.
-- Regards,
David Johnston
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]