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
