SCANTECH ID (Champtek company) RFS100 User Manual

Page 14

Advertising
background image

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)

Advertising