修改 表名 修改列

#修改 表名 修改列
update student set
studentName = '唐三' ,national = '蒙古族'
where studentNo = '20210102'

#将所有的民族都改为汉族
#禁忌
#不允许无where筛选条件的情况下使用update与delete操作
update student set national = '汉族';

delete from score where studentNo='20210101'or studentNo='20210102';
delete from student where classNo='202101';
delete from student where classNo='202102';