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