a command to organize numbers from 1 onwards in the db?

UrbanY

  • Jr. Member
  • Posts: 87

!

  • Sr. Member
  • Don't feel shy while zooming on h*r...
  • Posts: 361
Re: a command to organize numbers from 1 onwards in the db?
« Reply #1,  »
Use AUTO INCREMENT rather using custom made functions.
Quote
Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table.

Often this is the primary key field that we would like to be created automatically every time a new record is inserted.
Detailed Information & usage
Clicky