| select *
from page
left join category
on page.page_id = category.cat_pages
limit 500 |
2 years ago |
| select *
from page
left join category
on page.page_id = category.cat_pages
limit 20 |
2 years ago |
| select *
from page
left join category
on page.id = category.cat_pages
limit 20 |
2 years ago |
| describe page; |
2 years ago |
| select *
from page
where page_title = "Eiffel Tower" |
2 years ago |
| select *
from page
order by page_len
limit 20 |
2 years ago |
| select *
from page
order by page_len desc
limit 20 |
2 years ago |
| select *
from page
limit 20 |
2 years ago |
| select *
from page
where page_title = "%eiffel%" |
2 years ago |
| DESCRIBE page; |
2 years ago |
| SHOW TABLES; |
2 years ago |
| SELECT COUNT(*)
FROM revision_userindex
WHERE
rev_actor = (SELECT... |
2 years ago |
| show table pages |
2 years ago |
| describe |
2 years ago |
| describe |
2 years ago |
| describe |
2 years ago |
| describe |
2 years ago |
