| use enwiki;
select * from revision limit 5; |
9 years ago |
| use enwiki;
select * from user limit 5; |
9 years ago |
| use enwiki;
select * from user limit 5; |
9 years ago |
| use enwiki;
select * from user; |
9 years ago |
| use enwiki;
show tables; |
9 years ago |
| USE jawiki_p;
SELECT page_title FROM page
WHERE page_title LIKE "%ウィキペディア%"; |
9 years ago |
| USE jawiki_p;
SELECT page_title FROM page
WHERE page_title LIKE "%ウィキペディア%"; |
9 years ago |
| USE jawiki_p;
SELECT page_title FROM page
WHERE page_title LIKE "%???????%"; |
9 years ago |
| SELECT rev_user_text, COUNT(rev_id) AS total_edits FROM revision JOIN page... |
9 years ago |
| SELECT rev_user_text, COUNT(rev_id) AS total_edits FROM revision JOIN page... |
9 years ago |
| SELECT page_title FROM metawiki_p.page WHERE page_namespace = 2
AND... |
9 years ago |
| SELECT rev_user_text, COUNT(rev_id) AS total_edits FROM revision JOIN page... |
9 years ago |
| SELECT rev_user_text, COUNT(rev_id) AS total_edits FROM revision JOIN page... |
9 years ago |
| SELECT rev_user_text, COUNT(rev_id) AS total_edits FROM revision JOIN page... |
9 years ago |
