qfedu-linux-advanced-level/day9/delete_students.sql

9 lines
120 B
SQL

-- 删除测试
use studb;
create table if not exists t_stu3
select * from t_stu;
delete from t_stu3
where sex='';