MYSQL-DML操作

指定字段添加

insert into tb_emp(username,name,gender,create_time,update_time)
values ('wuji','无极','1',now(),now());

为所有字段添加

insert into tb_emp(id, username, password, name, gender, image, job, entrydate, create_time, update_time)
values (2, 'zzz', '123456', 'ZZZ', '2', '1.jpg', '1', '2023-10-01', now(), now());

批量插入

insert into tb_emp(username,name,gender,create_time,update_time)
values ('www','qqq','1',now(),now()),
       ('ccc','CCC','2',now(),now()),
       ('bbb','BBB','1',now(),now());

改字段:

update tb_emp set name='John Doe',update_time=now() where id=1;

改全表:

update tb_emp set entrydate='2025-10-01',update_time=now();

删除单列:
delete from tb_emp where id = 1;
删除整张表:
delete from tb_emp;