LucaMs Expert Licensed User Longtime User Dec 7, 2020 #1 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]
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 Expert Licensed User Longtime User Dec 7, 2020 #2 LucaMs said: What if my users who have an identifier field set as auto increment become more than 2,147,483,647? Click to expand... Until then you have sold the app and it is not your problem. Upvote 0
LucaMs said: What if my users who have an identifier field set as auto increment become more than 2,147,483,647? Click to expand... Until then you have sold the app and it is not your problem.
TILogistic Expert Licensed User Longtime User Dec 7, 2020 #3 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 Upvote 0
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 Expert Licensed User Longtime User Dec 7, 2020 #4 Alexander Stolte said: Until then you have sold the app and it is not your problem. Click to expand... 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 Upvote 0
Alexander Stolte said: Until then you have sold the app and it is not your problem. Click to expand... 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 Expert Licensed User Longtime User Dec 7, 2020 #5 oparra said: 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 Click to expand... I know how to reset that field, thank you, but I have to do by code (in my project): Upvote 0
oparra said: 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 Click to expand... I know how to reset that field, thank you, but I have to do by code (in my project):
TILogistic Expert Licensed User Longtime User Dec 7, 2020 #6 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 Upvote 0
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 Expert Licensed User Longtime User Dec 7, 2020 #7 oparra said: 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 Click to expand... Yes, it is so, I just truncated the image Upvote 0
oparra said: 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 Click to expand... Yes, it is so, I just truncated the image