1

I have table named ITEMS where there should be 2 auto increment columns.

So the table structure would be:

ID   |   ITEM_ID
---------------------------------
1    |   ITEM201521080225-001
2    |   ITEM201521080301-002
3    |   ITEM201521080345-003

The column.ITEM_ID structure is ITEMYearDayMonthHourMinute-Increment Value

I managed to Generate the ITEMYearDayMonthHourMinute value thru POST(PHP POST/ PHP Generated).

I am using MySQL and PHPMyAdmin at the moment, and I'm seeing errors if I set column.ITEM_ID to AUTO_INCREMENT

How can I make column.ITEM_ID to AUTO_INCREMENT? Is it Possible?

Aaron Alfonso
  • 141
  • 1
  • 2

0 Answers0