So, we have this table: ArpMon that looks like this:
-- mysql> describe ArpMon; +--------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+---------------+------+-----+---------+-------+ | am_mac | varchar(20) | | PRI | | | | am_ip | varchar(255) | | PRI | | | | am_rtr | varchar(255) | YES | | NULL | | | am_if | int(10) | YES | | NULL | | | am_ts | timestamp(14) | YES | | NULL | | +--------+---------------+------+-----+---------+-------+
When I do a count(*) on this table, we get this result:
mysql> select count(*) from ArpMon; +----------+ | count(*) | +----------+ | 27498 | +----------+ 1 row in set (0.01 sec)
Ok, that's good. But! If I run select * from ArpMon, I only get 111 entries
That's odd.
and if I run select count(am_rtr) from ArpMon, I get 111 entries as well as
That could, if you have only 111 non-NULL am_rtr values.
select am_rtr from ArpMon.
But! It I run select am_mac from ArpMon, I get the 27498 entries.
What's up with that? Can someone help me to figure this one out?
What does CHECK TABLE ArpMon tell you?
-James
James Kelty E-Commerce / Financial Systems Administrator Portland State University 503.725.9152 [EMAIL PROTECTED]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
