mysql插入一条记录，删除一条记录

来源：互联网发布：linux if语句多个条件编辑：程序博客网时间：2024/06/11 20:12

例如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';

阅读全文

0 0