| #describe externallinks;
select page_title, el_to from page, externallinks... |
9 years ago |
| describe externallinks;
#select page_title, el_name from page, externallinks... |
9 years ago |
| describe externallinks;
select page_title, el_name from page, externallinks... |
9 years ago |
| select page_title, el_name from page, externallinks where el_from = page_id limit 50; |
9 years ago |
| select * from page, externallinks where el_from = page_id limit 50; |
9 years ago |
| select * from page, externallinks where el_from = page_id order by page_id limit 50; |
9 years ago |
| select * from page, externallinks where el_from = page_id limit 50; |
9 years ago |
| select * from externallinks limit 50; |
9 years ago |
| show index from page; |
9 years ago |
| describe page; |
9 years ago |
| show table page; |
9 years ago |
| select page_id, page_title from page order by page_title desc limit 50 ; |
9 years ago |
| select page_id, page_title from page limit 50 order by page_title desc; |
9 years ago |
| select page_id, page_title from page limit 50 order by page_title descending; |
9 years ago |
| select page_id, page_title from page limit 50; |
9 years ago |
| describe page; |
9 years ago |
| show tables; |
9 years ago |
| select * from page where page_title where page_title like '*onkeys' limit 10; |
9 years ago |
| select * from page where page_title where page_title like '*onkeys' limit 10; |
9 years ago |
| select * from page where page_title where page_title like '*onkeys' limit 10; |
9 years ago |
| select * from page where page_title where page_title like '*_Monkeys' limit 10; |
9 years ago |
| select * from page where page_title where page_title like *_Monkeys limit 10; |
9 years ago |
| select * from page where page_title limit 50; |
9 years ago |
| select * from page where page_title limit 50; |
9 years ago |
| select * from page where page_title limit 50; |
9 years ago |
| select * from page where page_title limit 50; |
9 years ago |
| select * from page where page_title like '*' limit 50; |
9 years ago |
| select * from page where page_title like '*twig'; |
9 years ago |
| describe page; |
9 years ago |
| show page; |
9 years ago |
| show tables; |
9 years ago |
| select * from tables; |
9 years ago |
| select * from pages limit 50;
|
9 years ago |
| show tables;
|
9 years ago |
