例如mysql数据库有这么一条记录
表名是:h5user
+------------------------------+--------+------------+----------+-----------+---------+--------+------------------+
| opid | mccode | teacct | paydate | querydate | remarks | enable | withholding_flag |
+------------------------------+--------+------------+----------+-----------+---------+--------+------------------+
| ogmilwdtfHhJsjDKIfuyauhSQ5hE | 000536 | 12345678 | 20170522 | 24 | test | 1 | 0 |
现在需要再插入一条数据,命令如下:
insert into h5user (opid,mccode,teacct,paydate,querydate,remarks,enable,withholding_flag) values('o_XOw1bc51n3j1CyXmUIWguAnsO4','000536','12345678','20170731','28','test','1','0');
删除一条记录,命令如下:
delete from h5user where opid = 'o_XOw1bc51n3j1CyXmUIWguAnsO4';