DELETE FROM ... WHERE

create table studentfg
(

id int,
name varchar(20),
age int

);

insert into studentfg
values
(1,'张三',18),
(2,'李四',19),
(2,'王五',18),
(4,'赵六',20);

delete from studentfg
where id = 2;

delete from studentfg
where age = 20 and name = '赵六';

posted @ 2026-04-30 18:45  菜鸟的奋斗军  阅读(10)  评论(0)    收藏  举报