by - Code: Select all
-- Remove all trace of hand number 5, b1. (replace SELECT * with DELETE of course)
SELECT *
FROM ((((holdem_hand_summary
FULL OUTER JOIN holdem_hand_player_detail
ON holdem_hand_summary.id_hand = holdem_hand_player_detail.id_hand)
FULL OUTER JOIN holdem_hand_player_statistics
ON holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand)
FULL OUTER JOIN holdem_hand_histories
ON holdem_hand_summary.id_hand = holdem_hand_histories.id_hand)
FULL OUTER JOIN holdem_hand_player_combinations
ON holdem_hand_summary.id_hand = holdem_hand_player_combinations.id_hand)
WHERE holdem_hand_summary.id_hand = 5
I'm not sure what to do with the holdem_table_session_summary. I think that is the only table that isn't correctly affected by the purge query.
How is that table generated? Is it re-created or adjusted after each import?
If I were to go ahead with the above delete statement how many kittens would die?
