I'm trying to create a table in mySQL that will hold several thousand rows. What type, length and index to set for the cell that corresponds to the sequence number of the record? In particular, the Index column can take the values ​​Unique and Index, it seems to me that both are appropriate. Thanks in advance!

  • 2
    do the usual int and do not worry. size does not need to be set. Index is generally to speed up the search, it is not necessarily unique. what you want is very similar to the primary key, so declare the primary key on this field, and the unique MySQL index in this case will do it itself - Mike
  • @Mike thanks !! - Deka87

0