MySQL puts error #1439
Posted by:
njaohnt nja
Date: September 17, 2011 03:43PM
There is a problem with MySQL.
I put in
ALTER TABLE `points` CHANGE `personnum` `personnum` BIGINT( 18446744073709551615 ) UNSIGNED NOT NULL AUTO_INCREMENT
and it puts
#1439 - Display width out of range for column 'personnum' (max = 4294967295)
When I put in
ALTER TABLE `points` CHANGE `personnum` `personnum` BIGINT( 4294967295 ) UNSIGNED NOT NULL AUTO_INCREMENT
It says
#1439 - Display width out of range for column 'personnum' (max = 255)
What's wrong?
Subject
Written By
Posted
MySQL puts error #1439
September 17, 2011 03:43PM
September 20, 2011 05:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.