Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. SELECT CONCAT('DELETE FROM ',TABLE_NAME," WHERE Id = '1';") FROM information_schema.COLUMNS
  2. WHERE TABLE_SCHEMA = 'djangogirls'
  3. AND COLUMN_NAME ='Id';
  4.  
  5. DELETE FROM auth_group WHERE Id = '1';
  6. DELETE FROM auth_group_permissions WHERE Id = '1';
  7. DELETE FROM auth_permission WHERE Id = '1';
  8. DELETE FROM auth_user WHERE Id = '1';
  9. DELETE FROM auth_user_groups WHERE Id = '1';
  10. DELETE FROM auth_user_user_permissions WHERE Id = '1';
  11. DELETE FROM blog_post WHERE Id = '1';
  12. DELETE FROM django_admin_log WHERE Id = '1';
  13. DELETE FROM django_content_type WHERE Id = '1';
  14. DELETE FROM django_migrations WHERE Id = '1';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement