UC知道SQL一个很简单的问题！麻烦帮我确认一下。
来源：百度知道 编辑：UC知道 时间：2024/05/11 14:02:30
两个tables:
Person (driverID, name, address)
Car (registrationID, model, year, driverID)
现在题目要求写一个SQL Query,作用是 删除属于John Wong的Mazda（马自达）资料。
我写的是
DELETE CAR(*) FROM CAR, PERSON
WHERE MODERL = 'MAZDA'
AND NAME = 'John Wrong'
AND CAR.DRIVERID = PERSON.DRIVERID
这样对吗？主要是删除car表格里的资料。是写成“DELETE CAR(*) FROM CAR, PERSON”吗？？
Person (driverID, name, address)
Car (registrationID, model, year, driverID)
现在题目要求写一个SQL Query,作用是 删除属于John Wong的Mazda（马自达）资料。
我写的是
DELETE CAR(*) FROM CAR, PERSON
WHERE MODERL = 'MAZDA'
AND NAME = 'John Wrong'
AND CAR.DRIVERID = PERSON.DRIVERID
这样对吗？主要是删除car表格里的资料。是写成“DELETE CAR(*) FROM CAR, PERSON”吗？？
delete from car where driverid in (select driverid from person where NAME = 'John Wrong' )
语法不对。
delete from Person as P inner join Car on driverId=RegistrationId where Moderl='马自达'
主要没看到两个表之间的主外键关系，遗憾
delete
from car where MODERL = 'MAZDA'
AND NAME = 'John Wrong'
AND CAR.DRIVERID = PERSON.DRIVERID
试下 我也不怎么会。刚刚学SQL