| use wikidatawiki_p;
SELECT *
FROM page
WHERE page_title =... |
4 years ago |
| use wikidatawiki_p;
SELECT *
FROM page_props JOIN page ON page_id =... |
4 years ago |
| use wikidatawiki_p;
SELECT pp_page, pp_propname, pp_value
FROM page_props... |
4 years ago |
|
USE commonswiki_p;
SELECT CONCAT("Category:",page_title,"")
FROM page AS... |
4 years ago |
|
USE commonswiki_p;
SELECT CONCAT("Category:",page_title,"")
FROM page AS... |
4 years ago |
|
USE commonswiki_p;
SELECT CONCAT("Category:",page_title,"")
FROM page AS... |
4 years ago |
|
USE commonswiki_p;
SELECT CONCAT("Category:",page_title,"")
FROM page AS... |
4 years ago |
|
USE commonswiki_p;
SELECT CONCAT("Category:",page_title,"")
FROM page AS... |
4 years ago |
| page_title LIKE "%animat%" = 'Wellington Management Company' |
4 years ago |
| select * from industry where industry_name = 'Wellington Management Company' |
4 years ago |
| select Industry from article where article_name = 'Wellington Management Company' |
4 years ago |
