25 integer number auto icrement

[shah_ankitb]

I want primary key with auto increment with 25 digits. Big int is only provides 20.id 25 digits datatype?what data type we can use for this one in mysql phpmyadminData example :- 1234567891234567891234567

[justsomeguy]

You should be able to use decimal(25,0).

[shah_ankitb]

Not workingCREATE TABLE `abc`.`test` (`id` DECIMAL( 25, 0 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE = InnoDB;MySQL said: Documentation#1063 - Incorrect column specifier for column 'id' i have to define it as auto increment & primary key

[justsomeguy]

Auto-increment columns have to be integers, so use an int and set the size to 25. Do some tests to see if you can insert and retrieve values that large.

[shah_ankitb]

1] MYSQL int has max lengh of 11 & bigint has max length of 20. so it's not working for me2] PHP how can i add this 25 digitsi have3034074002003820000020when i'm doing +1 in to that it gives3.0340740020038E+21i need3034074002003820000021