create table xscj
(
age varchar(32),
name varchar(64),
km varchar(32),
mark float,
出生日期 datetime
)
insert into xscj(age,name,km,mark,出生日期)
values('1001','张三',',数学',85,2025-04-20),
('1001','英语',',英语',88,2025-04-22),
('1003','王五',',数学',76,2025-04-20),
('1002','数学',',数学',90,2025-04-20);
create view v_xscj
as
select *
from xscj;
select *
from v_xscj;
update xscj
set name = '李四'
where age = '1001'
select *
from xscj
go
Telegram: DB developers channel