views:

26

answers:

1

When adding a new data, can we automatically add a dynamic default data where the value is previous recorded data(0002)+1=0003

A: 

Not reliably. What will happen if multiple people access it at the same time is that data will be overwritten. Let the PK serve its purpose, behind the scenes.

Ignacio Vazquez-Abrams