| USE zhwikisource_p;
SELECT *
FROM `revision_userindex`
WHERE rev_page =... |
5 years ago |
| USE zhwikisource_p;
SELECT *
FROM `revision_userindex`
WHERE rev_page =... |
5 years ago |
| USE zhwikisource_p;
SELECT *
FROM `revision_userindex`
WHERE rev_page =... |
5 years ago |
| USE frrwiki_p;
SELECT
COUNT(*) as _count,
LEFT(rev_timestamp, 8) as... |
5 years ago |
| USE frrwiki_p;
SELECT
COUNT(*) as _count,
LEFT(rev_timestamp, 8) as... |
5 years ago |
| USE frrwiki_p;
SELECT
COUNT(*) as _count,
LEFT(rev_timestamp, 8) as... |
5 years ago |
| USE frrwiki_p;
SELECT LEFT(rev_timestamp, 6) as _day
FROM... |
5 years ago |
| USE frrwiki_p;
SELECT SUBSTR(rev_timestamp, 0, 6) as _day
FROM... |
5 years ago |
| USE frrwiki_p;
SELECT *
FROM `revision_userindex`
ORDER BY `rev_timestamp`... |
5 years ago |
| USE wikidatawiki_p;
SELECT
`comment_text` as `rev_comment`,... |
5 years ago |
| USE wikidatawiki_p;
SELECT `rev_comment`, `rev_timestamp`, `rev_minor_edit`,... |
5 years ago |
| SELECT `rev_comment`, `rev_timestamp`, `rev_minor_edit`, `rev_len`,... |
5 years ago |
| SELECT * from commonswiki_p.user where user_id=62513; |
5 years ago |
| SELECT * from commonswiki_p where user_id=62513; |
5 years ago |
| SELECT 1; |
5 years ago |
| SELECT * FROM archive WHERE ar_rev_id = 863745628 LIMIT 2; |
5 years ago |
| SELECT * FROM archive WHERE (ar_page_id = 58838027 OR ar_rev_id = 863745628) LIMIT 2; |
5 years ago |
| SELECT * FROM archive WHERE ar_page_id='58838027' LIMIT 2; |
5 years ago |
| DESCRIBE archive; |
5 years ago |
| ; |
7 years ago |
| select * from nlwiki_p.user limit 20; |
9 years ago |
| select * from user limit 20; |
9 years ago |
| describe user; |
9 years ago |
