DESCRIBE text; |
2 years ago |
DESCRIBE text; |
2 years ago |
DESCRIBE text; |
2 years ago |
SELECT * FROM text LIMIT 1 |
2 years ago |
SELECT * FROM pagecontent LIMIT 1 |
2 years ago |
SELECT * FROM text LIMIT 1 |
2 years ago |
SELECT * FROM text LIMIT 1 |
2 years ago |
WITH editions AS (
SELECT rev_actor, rev_id, rev_timestamp
FROM... |
2 years ago |
WITH editions AS (
SELECT rev_actor, rev_id, rev_timestamp
FROM... |
2 years ago |
WITH editions AS (
SELECT rev_actor, rev_id, rev_timestamp
FROM... |
2 years ago |
WITH editions AS (
SELECT rev_actor, rev_id, rev_timestamp
FROM... |
2 years ago |
WITH editions AS (
SELECT rev_actor, rev_id
FROM revision
WHERE... |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = 9009353
ORDER BY rev_timestamp DESC |
2 years ago |
SELECT * FROM revision WHERE rev_page = 9009353
ORDER BY DESC(rev_timestamp) |
2 years ago |
SELECT * FROM revision WHERE rev_page = 9009353
ORDER BY DESC(rev_timestamp) |
2 years ago |
SELECT * FROM revision WHERE rev_page = 9009353; |
2 years ago |
DESCRIBE revision; |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
AND page_title =... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
AND page_title = 'Linux'
|
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
AND page_title =... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
AND page_title LIKE 'Universidad%'
|
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
AND page_title LIKE... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
AND page_title = 'Linux'
|
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
AND page_title =... |
2 years ago |
SELECT *
FROM page
WHERE page_namespace = 0
page_title =... |
2 years ago |
SELECT *
FROM page
WHERE page_title = 'Linux' |
2 years ago |
SELECT *
FROM page
WHERE page_title = 'Universidad de IngenierĂa y TecnologĂa' |
2 years ago |
SELECT *
FROM revision JOIN page ON revision.rev_page = page.page_id
WHERE... |
2 years ago |
SELECT page_id = rev_page
FROM revision JOIN page ON revision.rev_page =... |
2 years ago |
SELECT *
FROM revision JOIN page ON revision.rev_page = page.page_id
LIMIT 1 |
2 years ago |
SELECT *
FROM revision JOIN page ON revision.rev_page = page.page_id |
2 years ago |
SELECT *
FROM revision JOIN page ON revision.rev_page = page.page_id. |
2 years ago |
DESCRIBE revision; |
2 years ago |
DESCRIBE revision_table; |
2 years ago |