| select * from ores_model |
6 years ago |
| show tables; |
6 years ago |
| describe page; |
6 years ago |
| select rev_user FROM revision WHERE rev_parent_id is null limit 100; |
6 years ago |
| select distinct rev_user FROM revision WHERE rev_parent_id is null; |
6 years ago |
| describe user; |
6 years ago |
| select count(*) from revision where rev_parent_id is null; |
6 years ago |
| explain select rev_user from revision limit 10 |
6 years ago |
| select rev_user from revision limit 10 |
6 years ago |
| explain select rev_user from revision |
6 years ago |
| explain select rev_user from revision order by rev_user desc limit 1; |
6 years ago |
| select rev_user from revision order by rev_user desc limit 1; |
6 years ago |
| select rev_user from revision limit 1 order by rev_user desc; |
6 years ago |
| select rev_user from revision limit 1; |
6 years ago |
| select count(*) from user where user_editcount > 0 |
6 years ago |
| describe user; |
6 years ago |
| SELECT count(*) FROM user |
6 years ago |
