# What I have to do with the content_address?
USE... |
6 years ago |
# What I have to do with the content_address?
USE... |
6 years ago |
# What I have to do with the content_address?
USE... |
6 years ago |
# What I have to do with the content_address?
USE... |
6 years ago |
# What I have to do with the content_address?
USE... |
6 years ago |
# What I have to do with the content_address?
USE... |
6 years ago |
USE wikidatawiki_p;
SELECT
revision.*,
content.*
FROM
revision,
... |
6 years ago |
USE wikidatawiki_p;
SELECT
content.*
FROM
revision,
slots,
... |
6 years ago |
USE wikidatawiki_p;
SELECT content.* FROM revision, slots, content WHERE... |
6 years ago |
USE wikidatawiki_p;
SELECT slots.* FROM revision, slots WHERE rev_page =... |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM revision WHERE rev_page = 4246474 LIMIT 100 ; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM revision LIMIT 100 WHERE rev_page = 4246474; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM revision LIMIT 1000; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM pagecontent LIMIT 1000; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM text LIMIT 1000; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM content LIMIT 1000; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM content LIMIT 10; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_changes WHERE change_object_id =... |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_changes WHERE change_object_id = Q10135... |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_changes LIMIT 30; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM revision LIMIT 30; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM page LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM content LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM pagecontent LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM text LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM slots LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM content LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM content LIMIT 1; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM content WHERE content_model =... |
6 years ago |
USE wikidatawiki_p;
EXPLAIN content; |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM page_props WHERE pp_page = 11534; |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM content_models |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_property_info LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_property_info LIMIT 1; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_id_counters; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_id_counters LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM wb_terms LIMIT 100; |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES; |
6 years ago |
SHOW DATABASES |
6 years ago |