SQL variable type for table id

Question

Usually when I need an ID for a database table, I just declare it as UNSIGNED INT, but what is the maximum value for this kind of ID? How can I know it? I'm using mysql server, but i think it would be useful to get an answer for all platforms. If I'm doing wrong, what kind of id should be used instead?

Well i COULD do that, but here I also ask for a practical advice. — Ben, Jan 23 '14 at 14:22

score 1 · Accepted Answer · answered Jan 23 '14 at 14:20

1

For MySQL max value in UNSIGNED INT, can be stored is 4294967295.

Have a look at Integer Storage in MySQL

answered Jan 23 '14 at 14:20

Abdul Manaf

4,768
3
27
34

SQL variable type for table id

1 Answers1