cassandra-CQL
describe keyspaces;
use falcon_gps;
select * from gps;
INSERT INTO gps (gprscode,gpstime,acc,alarmdes,direct,lat,lng,offset,posinfo,power,sendmodel,speed,status,statusdes,updatetime,vehicleid)
VALUES ('xxd001',2,3,'xxxxxx',5,6,7,8,'',10,11,12,13,'',15,16);
UPDATE gps SET alarmdes = 'yyyyyyyyy'
WHERE gprscode='xxd001' and gpstime =3;
delete FROM gps WHERE gpstime = 3 AND gprscode='xxd001';