查询单条
select * from ‘表名’ where ‘查询参数’='指定数据'
例如:select * from acmassetcostcenter where costcenter='9001'
查询所有
select * from ‘表名’
例如:select * from acmassetcostcenter
删除单条
delete from ‘表名’ where ‘删除参数’='指定数据'
例如:delete from acmassetcostcenter where costcenter='9001'
修改数据
update ‘表名’set ‘要修改的字段’='修改的指定数据' where ‘要修改的行项(唯一值)’='指定行项'
例如:update acmassetcostcenter set transfereq='1' where id='0b943cecf82f4fac8977f41486fd0f9c'