MySQL Forums
Forum List  »  MySQL Query Browser

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?

Options: ReplyQuote


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.