how to knwo how many devices register to FM from MySql.

SQLyou commend:

select i.* from device d, inventory i where d.inventoryid= i.inventoryid and d.connect = 0
select i.* from device d, inventory i where d.inventoryid= i.inventoryid and d.connect = 1
select d.* from device d, inventory i where d.inventoryid= i.inventoryid and d.connect = 1

0 = disconnect
1= connect

select * from hotzone_associate where check_time > '2009-06-18 16:00:00' and check_time < '2009-06-18 17:00:00' select * from inventory where serialNumber like '%159' select * from hotzone_associate_client where hotzone_associateId= 21543 select * from device where deviceId = 273 select * from hotzone_associate where ap_count > 100 and deviceId = 273
select count(*) from deviceattr

select * from device order by deviceId asc limit 20;