| select user_id, count(*)
from (select r.rev_user as user_id
... |
9 years ago |
| select user_id, count(*)
from (select r.rev_user as user_id
... |
9 years ago |
|
SELECT count(*)
AND revision_user = Titodutta |
9 years ago |
|
SELECT count(*)
AND user = Titodutta |
9 years ago |
|
SELECT count(*)
AND rev_user = Titodutta |
9 years ago |
| show tables from tewiki |
9 years ago |
| use bnwiki_p;
SELECT
p1.page_namespace,
p1.page_title
FROM page AS... |
9 years ago |
| SELECT
p1.page_namespace,
p1.page_title
FROM page AS p1
WHERE... |
9 years ago |
| USE gomwiki_p;
SELECT count(*)
FROM pagelinks
|
9 years ago |
| USE gomwiki_p;
SELECT count(*)
FROM page
|
9 years ago |
| USE gomwiki_p;
SELECT count(*)
FROM category
|
9 years ago |
| USE gomwiki_p;
SELECT
page_len
FROM category
|
9 years ago |
| USE gomwiki_p;
SELECT
page_len
FROM image
|
9 years ago |
| USE tewiki_p;
SELECT
page_len
FROM image
|
9 years ago |
| USE tewiki_p;
SELECT
page_title,
page_len
FROM image
|
9 years ago |
| USE tewiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM image
|
9 years ago |
| USE tewiki_p;
SELECT imagelinks; |
9 years ago |
| USE gomwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE gomwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE gomwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE gomwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE bnwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE bnwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE bnwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE bnwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE bnwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
9 years ago |
| USE bnwiki_p;
SELECT
user_name,
log_namespace,
log_timestamp,
... |
9 years ago |
| SELECT
user_name,
log_namespace,
log_timestamp,
log_action,
... |
9 years ago |
| $ sql enwiki_p < test-query.sql > test-query.txt |
9 years ago |
| $ sql enwiki_p < test-query.sql > test-query.txt |
9 years ago |
| $ sql enwiki_p < test-query.sql > test-query.txt |
9 years ago |
| $ sql enwiki_p < test-query.sql > test-query.txt |
9 years ago |
| $ sql enwiki_p < test-query.sql > test-query.txt |
9 years ago |
| $ sql enwiki_p |
9 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
9 years ago |
| SHOW TABLES FROM bnwiki_p; |
9 years ago |
| SHOW TABLES FROM enwiki_p; |
9 years ago |
| show tables from bnwiki |
9 years ago |
| DESCRIBE bnwiki_p.users; |
9 years ago |
| DESCRIBE bnwiki_p.page; |
9 years ago |
| {
"result": {
"Sum": {
"net_sum": 226254.0,
... |
9 years ago |
