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