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