odbtools/odbctest/mql/aaa/18prepare/13prepare_delete.mql

-- ============================================================
-- Prepare Delete 操作测试
-- ============================================================

-- 1. prepare delete 基本操作
insert into /test/aaa/test_prepare (p_name, p_int) values (?, ?)
/**
params("prep_delete_001", 1)
**/
;

delete from /test/aaa/test_prepare where p_name=?
/**
params("prep_delete_001")
**/
;

-- 验证已删除
select * from /test/aaa/test_prepare where p_name='prep_delete_001'
/**
output()
count(0)
**/
;

-- 2. prepare delete 多条件
insert into /test/aaa/test_prepare (p_name, p_int) values (?, ?)
/**
params("prep_delete_002", 100)
**/
;

delete from /test/aaa/test_prepare where p_name=? and p_int=?
/**
params("prep_delete_002", 100)
**/
;

select * from /test/aaa/test_prepare where p_name='prep_delete_002'
/**
output()
count(0)
**/
;

-- 3. prepare delete 不存在的记录
delete from /test/aaa/test_prepare where p_name=?
/**
params("prep_delete_non_exist")
**/
;