2-15.sql

来自「一个数据库的选课系统」· SQL 代码 · 共 10 行

SQL
10 行
字号
delete 
from students
where studentname='Joe Adams'

delete 
from enrolls
where enrolls.student=
     (select  enrolls.student
      from students,enrolls
      where students.student=enrolls.student and studentname='Joe Adams')

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?