| describe page; |
6 years ago |
| show tables; |
6 years ago |
| describe page; |
6 years ago |
| show tables; |
6 years ago |
| show tables; |
6 years ago |
| describe namespace; |
6 years ago |
| select distinct page_namespace, page_title from revision_userindex, page... |
6 years ago |
| select distinct rev_page, page_title from revision_userindex, page where... |
6 years ago |
| select distinct rev_page from revision_userindex, page where rev_user_text =... |
6 years ago |
| select distinct rev_page from revision_userindex, page where rev_user_text =... |
6 years ago |
| describe page; |
6 years ago |
| show tables; |
6 years ago |
| select distinct rev_page from revision_userindex where rev_user_text = 'Unst50'; |
6 years ago |
| select unique rev_page from revision_userindex where rev_user_text = 'Unst50'; |
6 years ago |
| select * from revision_userindex where rev_user_text = 'Unst50' limit 3; |
6 years ago |
| select * from revision_userindex where rev_user_text = 'Unst50'; |
6 years ago |
| select * from revision_userindex where rev_user_text = 'Unst50'; |
6 years ago |
| select * from revision_userindex limit 1; |
6 years ago |
| describe revision_userindex; |
6 years ago |
| show tables; |
6 years ago |
| show tables; |
6 years ago |
