有两个表,spawnlist
和npc
,我需要从spawnlsit
中删除数据.
我试过:
DELETE s FROM spawnlist s
INNER JOIN npc n ON s.npc_templateid = n.idTemplate
WHERE (n.type = "monster");
有两个表,spawnlist
和npc
,我需要从spawnlsit
中删除数据.
我试过:
DELETE s FROM spawnlist s
INNER JOIN npc n ON s.npc_templateid = n.idTemplate
WHERE (n.type = "monster");
在第一行中加.*
到s
.
try :
DELETE s.* FROM spawnlist s
INNER JOIN npc n ON s.npc_templateid = n.idTemplate
WHERE (n.type = "monster");