ID Field

[wuxapian]

Hi,

I need to create a table with one record in it that stores a number. This number will then be accessed and then incremented by an application, which requires a sequential but unique number as part of a product code.

Does anyone know of a reliable method for grabbing and then incrementing a value from a table bearing in mind that multiple users could be using it at the same time?

TIA
Wux.

 

[piti]

this should work

1. LOCK TABLES table_name WRITE;
3. UPDATE tablename SET int_column = (int_column + 1);
4. UNLOCK TABLES;

 

[wuxapian]

Thanks for that piti, I will give it a go.

Wux.