Hi all, I have a small problem - I have the following table with numetic type. In my table is mediumint(6), but I can to insert value 11223344. I thougth the maximum value for mediumint(6) is 999999.
Do you have some idea what I should to do to be able insert value 999999 as a maximum for my field? My table: CREATE TABLE `table` ( `id_a` mediumint(6) unsigned NOT NULL default '0', `id_b` mediumint(6) unsigned NOT NULL default '0', `id_c` mediumint(6) unsigned NOT NULL default '0', `area` char(2) NOT NULL default '', `group` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id_a`,`id_a`,`id_b`) ) TYPE=MyISAM Background: MySQL version 3.23.49 on Red Hat Linux 7.3. Thank tou very much for your help. Regards, Jan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
