| -- show tables from wikidatawiki_p;
use wikidatawiki_p;
describe page; |
3 years ago |
| show tables from wikidatawiki_p; |
3 years ago |
| show wikidatawiki_p; |
3 years ago |
| show wikidata; |
3 years ago |
| blank query |
3 years ago |
| select * from frwiki_p.page
join revision on rev_page=page_id
... |
3 years ago |
| select * from frwiki_p.page
join revision on rev_page=page_id
... |
3 years ago |
| select * from frwiki_p.page
join revision on rev_page=page_id and... |
3 years ago |
| select * from frwiki_p.page
join revision on rev_page=page_id and... |
3 years ago |
| select * from frwiki_p.page
join revision on rev_page=page_id and... |
3 years ago |
| select * from frwiki_p.page
where page_latest > 20201115;
|
3 years ago |
| describe frwiki_p.page;
|
3 years ago |
| select * from frwiki_p.page;
limit 20; |
3 years ago |
| select count(*) from frwiki_p.page; |
3 years ago |
| describe page; |
3 years ago |
| SHOW TABLES FROM frwiki_p;
|
3 years ago |
| SELECT actor_id
FROM actor
WHERE... |
3 years ago |
| SELECT actor_id
FROM actor
WHERE... |
3 years ago |
