| use cswiki_p;
select * from logging u where log_user = 6216 and log_type = 'newusers' |
6 years ago |
| use cswiki_p;
select u.* from user u where user_id = 6216 |
6 years ago |
| use cswiki_p;
select u.* from user u
left join (select * from logging where... |
6 years ago |
| use cswiki_p;
select count(*) from user where user_registration >= 20100101000000 |
6 years ago |
| use cswiki_p;
select count(*) from user where user_registration is not null |
6 years ago |
| use cswiki_p;
select count(*) from user where user_registration is null |
6 years ago |
| use cswiki_p;
select * from user limit 10 |
6 years ago |
| use cswiki_p;
select count(*) from user |
6 years ago |
| use cswiki_p;
select * from user where user_name like 'MMiller (WMF)' |
6 years ago |
| use cswiki_p;
select * from user where user_name = 'MMiller_(WMF)' |
6 years ago |
| use cswiki_p;
select * from user where user_name = 'Urbanecm' |
6 years ago |
| use cswiki_p;
select * from user limit 10 |
6 years ago |
