Skip to content

Instantly share code, notes, and snippets.

@slick2
Created July 2, 2015 15:51
Show Gist options
  • Save slick2/8525916ff7344e8754d8 to your computer and use it in GitHub Desktop.
Save slick2/8525916ff7344e8754d8 to your computer and use it in GitHub Desktop.
SQL remove
SET SQL_SAFE_UPDATES = 0;
SET @my_id = 4;
SELECT l.*, u.*
FROM user u INNER JOIN login l ON u.login_id = l.id
WHERE l.id = @my_id;
DELETE FROM user where login_id = @my_id;
DELETE FROM login WHERE id = @my_id;
DELETE FROM user_links WHERE login_id = @my_id;
SELECT l.*, u.*
FROM user u INNER JOIN login l ON u.login_id = l.id
WHERE l.id = @my_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment