At 23:05 +0200 9/11/02, Jan Kudrman wrote: >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.
Why? > >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
