| select page_id, page_title from page where page_namespace=0 AND page_is_redirect=0 ; |
1 year ago |
| select page_id, page_title from page where page_namespace=0 AND... |
1 year ago |
| select page_id, page_title from page where page_namespace=0 AND page_is_redirect=0; |
1 year ago |
| select page_id, page_title from page where page_namespace=0 AND... |
1 year ago |
| select * from page where page_namespace=0 AND page_is_redirect=0 limit 10; |
1 year ago |
| select COUNT(*) from page where page_namespace=0 AND page_is_redirect=0; |
1 year ago |
| select COUNT(*) from page where page_namespace=0 AND page_is_redirect=1 ; |
1 year ago |
| select * from page where page_namespace=0 AND page_is_redirect=1 limit 10; |
1 year ago |
| select * from page where page_namespace=0 AND page_is_redirect=0 limit 10; |
1 year ago |
| select * from page where page_namespace=0 limit 10; |
1 year ago |
| select page_namespace from page where page_namespace=0 limit 10; |
1 year ago |
| select page_namespace,COUNT(*) from page GROUP BY page_namespace; |
1 year ago |
| select COUNT(*) from page GROUP BY page_namespace; |
1 year ago |
| select * from page limit 10; |
1 year ago |
| select * from content limit 10; |
1 year ago |
| SHOW TABLES;
|
1 year ago |
| SHOW TABLES;
|
1 year ago |
| SHOW TABLES;
|
1 year ago |
| SHOW TABLES;
|
1 year ago |
| SHOW TABLES;
|
1 year ago |
| show tables; |
1 year ago |
| show tables; |
1 year ago |
| show tables; |
1 year ago |
| show tables; |
1 year ago |
| show tables; |
1 year ago |
| show tables; |
1 year ago |
| select COUNT(DISTINCT page_title) from page limit 10; |
1 year ago |
| select COUNT(page_title) from page limit 10; |
1 year ago |
| select * from page limit 10; |
1 year ago |
| select * from page; |
1 year ago |
| select * from page limit 10; |
1 year ago |
| select COUNT(*) from page limit 10; |
1 year ago |
| select * from page limit 10; |
1 year ago |
| show tables; |
1 year ago |
| -- show tables;
select * from content limit 20; |
1 year ago |
| show tables;
-- select COUNT(*) from actor; |
1 year ago |
| -- show tables;
select COUNT(*) from actor; |
1 year ago |
| -- show tables;
select COUNT(*) from sites; |
1 year ago |
| -- show tables;
select * from sites; |
1 year ago |
| -- show tables;
select * from sites limit 10; |
1 year ago |
| show tables; |
1 year ago |
| select * from actor limit 10; |
1 year ago |
| show tables; |
1 year ago |
| select * from enwiki_p limit 10; |
1 year ago |
| select * from enwiki limit 10; |
1 year ago |
| select * from enwiki limit 10; |
1 year ago |
| select * from meta_p.enwiki limit 10; |
1 year ago |
| select * from enwiki limit 10; |
1 year ago |
