从2个表IF中删除2个条目 [英] delete 2 entries from 2 tables IF

问题描述

我正在运行一个游戏服务器，我有2个条目我想删除。



游戏将玩家用户ID记录在2个单独的表格中：



1）player_login

2）character_data



character_data有我想要的lastlogin和playeruid信息一个查询从player_login和character_data中删除条目，如果lastlogin超过一周，我现在有这个但我不确定它是否正确，如果我将其更改为删除我相信它只会从character_data中删除

I am running a gameserver, i have 2 entries i am trying to delete.

The game logs player user id's in 2 seperate tables:

1) player_login
2) character_data

character_data has lastlogin and playeruid information i want a query that deletes the entry from player_login and character_data if the lastlogin was longer than a week i have this at the moment but im not sure if its correct and if i changed it to delete i believe it would only delete from character_data

SELECT count(*) FROM character_data
WHERE EXISTS
  ( select PlayerUID
    from player_login 
		where (character_data.LastLogin <= NOW() - INTERVAL 7 day)
);

推荐答案

CREATE TRIGGER ....删除之后等等



所以现在你只需要处理一个表并使其触发器处理另一个表。

CREATE TRIGGER .... AFTER DELETE on ... etc

So now you only need handle one table and have its trigger handle the other.

这篇关于从2个表IF中删除2个条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！