PI SQL 语句

insert [piarchive]..[picomp2](tag,time,value) values('ppnie_test','t',100)

INSERT into pipoint..classic (tag, pointtypex,engunits) VALUES ('ppnie_test', 'float32','℃');

select * from [piarchive]..[picomp2] where tag='ppnie_test'

-- Deletes the "TestTag2".
DELETE pipoint..classic WHERE tag = 'ppnie_test'

select * from pipoint..classic  WHERE tag = 'ppnie_test'

posted @ 2018-01-16 16:45  panie2015  阅读(541)  评论(0编辑  收藏  举报