0

I have a brief question. When creating my database in phpmyadmin, I have a table name of all_points. The type is INT. How do I set the value or length to unlimited so it can be however long I wish it to be? Is that not what length/values does? Any help would be appreciated with kindness. (Just starting out in PHP)

Phil
  • 157,677
  • 23
  • 242
  • 245
  • 2
    If you're talking about the number in brackets, ie `INT(4)`, that's just the [display width](https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html). MySQL's integer data types all have fixed ranges but some can support very large numbers. See https://dev.mysql.com/doc/refman/8.0/en/integer-types.html – Phil Sep 07 '20 at 01:55
  • so the max is 4294967295 –  Sep 07 '20 at 01:57
  • 2
    For an unsigned `INT`, yes. If you need larger numbers, use `BIGINT` – Phil Sep 07 '20 at 01:58
  • thanks! but what does unassigned mean –  Sep 07 '20 at 02:01
  • But when I put 4294967295 it says display width out of range - max 255 –  Sep 07 '20 at 02:03
  • _**Unsigned**_, not _unassigned_. See [Signed versus Unsigned Integers](https://stackoverflow.com/questions/247873/signed-versus-unsigned-integers) – Phil Sep 07 '20 at 02:03
  • so if I leave it blank? –  Sep 07 '20 at 02:04
  • Just to be clear, leaving it blank gives it a value of 4294967295 –  Sep 07 '20 at 02:06
  • I suggest you read all the links I've provided, particularly [this one](https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html) and the duplicate question link – Phil Sep 07 '20 at 02:07
  • Ok thanks for your time! –  Sep 07 '20 at 02:08

0 Answers0