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 and if I run select count(am_rtr) from ArpMon, I get 111 entries as well as 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? -James James Kelty E-Commerce / Financial Systems Administrator Portland State University 503.725.9152 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
