- To get the username and e-mail list of all users of your program ordered by signup time simply enter:
select Username,E_Mail from GPTE_Members order by Signup_Time
- To get a list of number of users by country in descending order, enter:
select count(*) as Numb,Country from GPTE_Members group by Country order by Numb desc
- To get a list of users who have e-mail with the domain bad_domain.com, enter:
select Username,E_Mail from GPTE_Members where E_Mail like '%\@bad_domain.com' order by Username
- To give 100 points bonus for users with more than 12 months since signup, enter:
update GPTE_Members set Points = Points + 100 where unix_timestamp(Signup_Time) < unix_timestamp(now() - interval 12 month)
- To disable the turing number check for the user foo_user, enter:
insert into GPTE_Non_Turing_Number_Users values ('foo_user')
- To list the IP number of the last 25 visitors of your site, enter:
select distinct IP from GPTE_Online_Visitors order by Action_Time desc limit 25
- To list the top 5 selling advertising packages, enter:
select Name,count(*) as The_Sum from GPTE_Shopping_Box group by Name order by The_Sum desc limit 5
- To list the last 10 deleted users, enter:
select Username,E_Mail,Signup_Time,Unsubscribe_Time from GPTE_Deleted_Users order by Unsubscribe_Time desc limit 10
- Etc, etc...