Auto generate new document numbers

[Toro22]

Hi

Im making a database to store document references for drawings. One of the main points are to generate muliple part document numbers of the type 004-007-2003-KSQ - from the logged on user, current project etc.

There is a possiblillty for several users to be creating documents at the same time, so It has to be the server creating the new doc. number when creating the new row.

The database is accessed via a Delphi front end.

Any help/pointers very welcome ! Thanks !

 

[ingresman]

Have you looked at auto_increment ?

 

[rzs0502]

Would it be possible to use date/time stamps?

mysql> select concat(current_date()+0,current_time()+0) as stamp
-> ;
+----------------+
| stamp |
+----------------+
| 20041230160831 |
+----------------+

with

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

for formatting



"If you always do what you've always done, you will always be where you've always been."