SQL query for phpMyAdmin to delete authenticated users Question 1: I would like an sql statement to use in phpMyAdmin to delete the users with the role: authenticated user. Looks like rid = 2. 

Related Question 2: I show thousands of users in admin/people but the query: 
SELECT * FROM drup_users WHERE 1
only shows 30 users. Shouldn't they all be there?

Related Question 3: I created several roles but only the three standard roles appear using:
SELECT * FROM drup_role WHERE 1
Where are all the roles I created? 

I think I'm having some gross conceptual error. I would appreciate any guidance :)  Thanks!
As mentioned in the comments, directly modifying the tables could be disastrous.  If you need to get rid of large numbers of users I would suggestion Using Views with Views Bulk Operations:


  You need Views if
  
  You like the default front page view, but you find you want to sort it
  differently. You like the default taxonomy/term view, but you find you
  want to sort it differently; for example, alphabetically. You use
  /tracker, but you want to restrict it to posts of a certain type. You
  like the idea of the 'article' module, but it doesn't display articles
  the way you like. You want a way to display a block with the 5 most
  recent posts of some particular type. You want to provide 'unread
  forum posts'. You want a monthly archive similar to the typical
  Movable Type/Wordpress archives that displays a link to the in the
  form of "Month, YYYY (X)" where X is the number of posts that month,
  and displays them in a block. The links lead to a simple list of posts
  for that month.


This module augments Views by allowing bulk operations to be executed
 on the displayed rows. It does so by showing a checkbox in front of
 each node, and adding a select box containing operations that can be
 applied. Drupal Core or Rules actions can be used.