| select page_id, page_title from hewiki_p.page
#where page_id <=... |
7 years ago |
| select page_id, page_title from hewiki_p.page
#where page_id <= 700000
where... |
7 years ago |
| select page_id, page_title from hewiki_p.page
#where page_id <= 700000
where... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_id <= 700000
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select count(*) from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_id, page_title from hewiki_p.page
where page_namespace = 0
and... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page
where page_namespace = 0
and not... |
7 years ago |
| select page_title from hewiki_p.page where page_namespace = 0 and not... |
7 years ago |
| use hewiki_p;
show tables;
|
9 years ago |
| use hewiki_p;
select * from user
join watchlist on user_name = 'בורה... |
9 years ago |
| use hewiki_p;
select * from user
join hitcounter on user_name = 'בורה... |
9 years ago |
| use hewiki_p;
select * from user
where user_name = 'בורה בורה'
join... |
9 years ago |
| use hewiki_p;
select * from user
where user_name = 'בורה בורה'
|
9 years ago |
| use hewiki_p;
select * from user
where user_name = 'בורה_בורה'
|
9 years ago |
| use hewiki_p;
select * from user
where user_name = 'IKhitron'
|
9 years ago |
| use frwiki_p;
select * from geo_tags
JOIN page on gt_page_id = page_id and... |
9 years ago |
| use frwiki_p;
select * from geo_tags
JOIN page on gt_page_id = page_id and... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from geo_tags
JOIN page on gt_page_id = page_id and... |
9 years ago |
| use hewiki_p;
select * from geo_tags
JOIN page on gt_page_id = page_id and... |
9 years ago |
| use hewiki_p;
select * from geo_tags
JOIN page on gt_page_id = page_id and... |
9 years ago |
| use hewiki_p;
select * from geo_tags
JOIN page on gt_page_id = page_id and... |
9 years ago |
| use hewiki_p;
describe geo_tags;
describe page;
select * from geo_tags
JOIN... |
9 years ago |
| use hewiki_p;
describe geo_tags;
describe page;
select page.*, geo_tags.*... |
9 years ago |
| use hewiki_p;
describe geo_tags;
describe page;
select page.* from... |
9 years ago |
| use hewiki_p;
describe geo_tags;
describe page;
select *, page.page_title... |
9 years ago |
| use hewiki_p;
describe geo_tags;
describe page;
select * from geo_tags
JOIN... |
9 years ago |
| use hewiki_p;
describe geo_tags;
select * from geo_tags
JOIN page on... |
9 years ago |
| use hewiki_p;
select * from geo_tags
JOIN page on gt_page_id = page_id and... |
9 years ago |
| use hewiki_p;
select geo_tags.*, page.page_title from geo_tags as he
JOIN... |
9 years ago |
| use hewiki_p;
select *, page.page_title from geo_tags as he
JOIN page on... |
9 years ago |
| use hewiki_p;
select *, page._page_title from geo_tags as he
JOIN page on... |
9 years ago |
| use hewiki_p;
select * from geo_tags as he
JOIN page on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from page as he
JOIN geo_tags on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from page as he
JOIN geo_tags on gt_page_id = page_id... |
9 years ago |
| use hewiki_p;
select * from page
JOIN geo_tags on gt_page_id = page_id
where... |
9 years ago |
| use hewiki_p;
select * from page
JOIN page on gt_page_id = page_id
where... |
9 years ago |
| use hewiki_p;
select * from page
where gt_country = 'FR'
JOIN page on... |
9 years ago |
| use hewiki_p;
select * from geo_tags
where gt_country = 'FR' |
9 years ago |
| use hewiki_p;
select gt_country from geo_tags
group by gt_country |
9 years ago |
| use hewiki_p;
select gt_country from geo_tags |
9 years ago |
| use hewiki_p;
describe geo_tags;
|
9 years ago |
| use hewiki_p;
describe geo_tags;
select gt_country |
9 years ago |
| use hewiki_p;
describe geo_tags;
select * from geo_tags where gt_country='fr' |
9 years ago |
| use hewiki_p;
describe geo_tags;
select * from geo_tags where gt_country=fr |
9 years ago |
| use hewiki_p;
describe geo_tags;
select * from geo_tags on gt_country=fr |
9 years ago |
| use hewiki_p;
describe geo_tags;
select * from geo_tags
|
9 years ago |
| use hewiki_p;
describe geo_tags;
select * from geo_tags
join page on... |
9 years ago |
| use hewiki_p;
select * from geo_tags
join page on page.page_id =... |
9 years ago |
| use hewiki_p;
select * from gt_id
join page on page.page_id = gt.gate_id and... |
9 years ago |
| describe hewiki_p.geo_tags
|
9 years ago |
| SHOW tables from hewiki_p;
describe hewiki_p.geo_tags
|
9 years ago |
| SHOW tables from hewiki_p;
describe hewiki_p.geotags
|
9 years ago |
| SHOW tables from hewiki_p;
|
9 years ago |
| DESCRIBE wikidatawiki_p.langlinks;
SHOW tables from wikidatawiki_p;
|
9 years ago |
| DESCRIBE wikidatawiki_p.globalblocks;
SHOW tables from wikidatawiki_p;
|
9 years ago |
| DESCRIBE wikidatawiki_p.externallinks;
SHOW tables from wikidatawiki_p;
|
9 years ago |
| DESCRIBE wikidatawiki_p.interwiki;
SHOW tables from wikidatawiki_p;
|
9 years ago |
| DESCRIBE wikidatawiki_p.interwiki
SHOW tables from wikidatawiki_p;
|
9 years ago |
| SELECT *
FROM hewiki_p.page where hewiki_p.page.page_title =... |
9 years ago |
| SELECT *
FROM hewiki_p.page where hewiki_p.page.page_title =... |
9 years ago |
| SELECT *
FROM hewiki_p.page where hewiki_p.page.page_title =... |
9 years ago |
| SELECT *
FROM hewiki_p.page where hewiki_p.page.page_title = "אדי_קבטנר" |
9 years ago |
| USE hewiki_p;
USE wikidatawiki_p;
|
9 years ago |
| USE hewiki_p, wikidatawiki_p;
|
9 years ago |
| USE wikidatawiki_p;
SHOW tables;
|
9 years ago |
| USE wikidatawiki_p;
DESCRIBE tables;
|
9 years ago |
| USE wikidatawiki_p;
SHOW tables;
|
9 years ago |
| USE hewiki_p;
SHOW tables;
|
9 years ago |
