| SELECT p1.page_title 'page title', cl_to 'category' FROM categorylinks INNER... |
7 years ago |
| SELECT p1.page_title 'page title', cl_to 'category' FROM categorylinks INNER... |
7 years ago |
| Select COUNT(1) from categorylinks; |
7 years ago |
| Select COUNT(1) from page; |
7 years ago |
| SELECT cl_to from categorylinks where cl_from = 25412; |
7 years ago |
| SELECT cl_to from categorylinks; |
7 years ago |
| SELECT cl_to from categorylink; |
7 years ago |
| use enwiki_p;
|
7 years ago |
| show databases;
|
7 years ago |
| Select * from page; |
7 years ago |
| Select * from pages; |
7 years ago |
| #SELECT p1.page_title 'page title', cl_to 'category' FROM categorylinks... |
7 years ago |
| #SELECT p1.page_title 'page title', cl_to 'category' FROM categorylinks... |
7 years ago |
| SELECT p1.page_title 'page title', cl_to 'category' FROM categorylinks INNER... |
7 years ago |
| show tables;
|
7 years ago |
