Other DB - auto incremented field

[LucaMs]

What if my users who have an identifier field set as auto increment become more than 2,147,483,647?


[In the meantime I am thinking of changing that identifier to text field generated by my project, I think it is better]

 

[Alexander Stolte]

What if my users who have an identifier field set as auto increment become more than 2,147,483,647?

Until then you have sold the app and it is not your problem.

 

[TILogistic]

MYSQL.

TINYINT - 127
UNSIGNED TINYINT - 255
SMALLINT - 32767
UNSIGNED SMALLINT - 65535
MEDIUMINT - 8388607
UNSIGNED MEDIUMINT - 16777215
INT - 2147483647
UNSIGNED INT - 4294967295
BIGINT - 9223372036854775807
UNSIGNED BIGINT - 18446744073709551615

 

[LucaMs]

Until then you have sold the app and it is not your problem.

A young Italian IT entrepreneur sold one of his businesses for $100 million. He is now in jail for raping an 18-year-old girl, but that is irrelevant

 

[LucaMs]

MYSQL.

¿Cómo reiniciar AUTO_INCREMENT en MySQL?

¿Cómo puedo restablecer el auto_increment de un campo? Quiero que comience a contar de nuevo desde 1.

stackoverrun.com

TINYINT - 127
UNSIGNED TINYINT - 255
SMALLINT - 32767
UNSIGNED SMALLINT - 65535
MEDIUMINT - 8388607
UNSIGNED MEDIUMINT - 16777215
INT - 2147483647
UNSIGNED INT - 4294967295
BIGINT - 9223372036854775807
UNSIGNED BIGINT - 18446744073709551615

I know how to reset that field, thank you, but I have to do by code (in my project):

 

[TILogistic]

ALTER TABLE tablename AUTO_INCREMENT = value;
reference: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Another way is to change the field type
If you don't want to reset

 

[LucaMs]

ALTER TABLE tablename AUTO_INCREMENT = value;
reference: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Another way is to change the type
If you don't want to reset

Yes, it is so, I just truncated the image