SCANTECH ID (Champtek company) RFS100 User Manual
Page 14
User Manual – RFS100 Concentrator
Data properties
tagid VARCHAR(20) NOT NULL
readername VARCHAR(20) NOT NULL
group INTEGER NOT NULL
gettime VARCHAR(20) NOT NULL
rssi INTEGER NOT NULL
tagstatus VARCHAR(10) NOT NULL
tmp VARCHAR(10) NOT NULL
reverse1 VARCHAR(20) NOT NUL
reverse2 VARCHAR(20) NOT NULL
reverse3 VARCHAR(20) NOT NULL
SQL Command Example (Please refer to MySQL heap command for
details)
SQL:select * From active_tags_Table (Query all data in
active_tags_table)
SQL:select tagid,readername,rssi,gettime from active_tags_table
where tagid="000180" order by gettime desc limit 5
(Query tagid/readername/rssi/gettime that in the last 5 rows of
data)
select tagid,readername from active_tags_table where tagid =
“000195” (Query the tagid /readername that tagid equals
000195 in the rows)