dhbin / ra Goto Github PK

create table tb_user
(
    id       bigint primary key not null auto_increment,
    username varchar(100)       not null,
    pwd      varchar(100)       not null,
    sex      varchar(10)        not null
);

insert into tb_user (username, pwd, sex)
values ('张三', '123456', '男'),
       ('李四', '111111', '女'),
       ('kk', '1111', '男');

delete from tb_user where id != 0;

delete from `test`.`tb_user` where id = 1 and username = '张三' and pwd = '123456' and sex = '男' limit 1; # pos 5726 timestamp 1682469713