odbtools/odbctest/mql/basic/13tuihualei/13tuihualei.mql

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

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

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

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

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

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

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

delete from /test/tuihualei
;

select * from /test/tuihualei
/**
count(0)
**/
;