odbtools/odbctest/mql/basic/13delete/15mdelete.mql

select * from /test/delete where v_date = '2019-10-22'
/**
count(1)
**/
;

delete from /test/delete where v_date = '2019-10-22'
;

select * from /test/delete where v_date = '2019-10-22'
/**
count(0)
**/
;

select * from /test/delete where v_timestamp = '2019-10-21'
/**
count(2)
**/
;

select * from /test/delete where v_timestamp = '2019-10-21 23:57'
/**
count(1)
**/
;

select * from /test/delete where v_timestamp = '2019-10-21 23:'
/**
count(1)
**/
;

delete from /test/delete where v_timestamp = '2019-10-21 23:57'
;

select * from /test/delete where v_timestamp = '2019-10-21 23:57'
/**
count(0)
**/
;

select * from /test/delete
/**
count(1)
**/
;