清空表中所有记录
truncate table et_xxxxxx

删除一条数据

DELETE FROM zhubajie_member.mb_web_login WHERE nickname='m_3215_6770'

更新一条数据
update et_ticket set auif='123123' where tknb='9991673178540'

 
增加一条数据
INSERT INTO "R_EMP_ROLE"(
"EMP", "ROLE")
VALUES ((select "ID" from "TS_EMP" where "NMAE"=''), (SELECT "ID" from "TS_S_ROLE" where "NAME" ='A_DEPT'));

insert into `zhubajie_bill_service`.`bl_merchant`(`merchant_id`,`merchant_name`,`create_time`,`update_time`,`tax_id`,`enable`)
values ('merchant_id','merchant_name','create_time','update_time','tax_id','enable');