USE wikidatawiki_p;
show tables ;
select * from user_properties where... |
6 years ago |
USE wikidatawiki_p;
show tables ;
select * from user_properties limit 1000; |
6 years ago |
USE wikidatawiki_p;
show tables ;
select * from user limit 100; |
6 years ago |
USE wikidatawiki_p;
select * from user limit 100; |
6 years ago |
USE wikidatawiki_p;
select * from users limit 100; |
6 years ago |
USE wikidatawiki_p;
show tables; |
6 years ago |
USE wikidatawiki_p;
select * from user_properties_anon limit 100; |
6 years ago |
USE wikidatawiki_p;
select distinct up_property from user_properties_anon limit 100; |
6 years ago |
USE wikidatawiki_p;
select distinct up_property from user_properties limit 100; |
6 years ago |
USE wikidatawiki_p;
select * from user_properties limit 100; |
6 years ago |
USE wikidatawiki_p;
show tables; |
6 years ago |
USE wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
6 years ago |
USE wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
6 years ago |
USE wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT *
FROM wb_terms
WHERE... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT DISTINCT *
FROM... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT DISTINCT CONCAT("Q",... |
6 years ago |
use wikidatawiki_p;
DESCRIBE wb_terms;
SELECT * FROM wb_terms WHERE... |
6 years ago |