List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 11 2002 9:53pm
Subject:Re: mediumint(6) problem
View as plain text  
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

Thread
mediumint(6) problemJan Kudrman12 Sep
  • Re: mediumint(6) problemPaul DuBois12 Sep
RE: mediumint(6) problemKenneth Hylton12 Sep