문서의 선택한 두 판 사이의 차이를 보여줍니다.
다음 판 | 이전 판 | ||
jaunt_maunal [2018/07/25 03:04] gsjung 만듦 |
jaunt_maunal [2021/04/13 06:54] (현재) |
||
---|---|---|---|
줄 1: | 줄 1: | ||
===== Jaunt Manual ===== | ===== Jaunt Manual ===== | ||
+ | Traccar Document: [[https:// | ||
DBMS: [[https:// | DBMS: [[https:// | ||
줄 29: | 줄 29: | ||
< | < | ||
| | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | COPY (select * from positions p, devices d where p.deviceid=d.id AND d.uniqueid IN (SELECT uniqueid FROM devices WHERE uniqueid LIKE ######)) TO '#########' | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | select d.name, p.* from tc_positions p, tc_devices d where p.deviceid = d.id and d.id IN (select id from tc_devices where name=ANY(' | ||
</ | </ |