sql query example

http://www.w3schools.com/sql/sql_insert.asp

sqlite> update sphoto set SpaceUID='space1' where FileName='pic1.png';

sqlite> select * from sphoto where SpaceUID='myspace';

sqlite> insert into suid values ('2','space1','1');

http://www.w3schools.com/sql/sql_join_inner.asp

sqlite> SELECT DeviceID FROM OwnerManage JOIN GuestPermission WHERE OwnerManage.SpaceUID='Spc0000003' AND (GuestPermission.Permission='R/W' OR GuestPermission.Permission='R');

http://www.w3schools.com/sql/sql_distinct.asp

sqlite> SELECT DISTINCT DeviceID FROM OwnerManage JOIN GuestPermission WHERE OwnerManage.SpaceUID='Spc0000003' AND (GuestPermission.Permission='R/W' OR GuestPermission.Permission='R');