| SELECT*
FROM revision
LEFT JOIN page on revision.rev_page =... |
1 year ago |
| SELECT*
FROM revision
WHERE rev_page="Paris"
|
1 year ago |
| SELECT*
FROM revision
WHERE rev_page='Paris'
|
1 year ago |
| SELECT count( distinct(rev_page)), count(*)
FROM revision
WHERE... |
1 year ago |
| SELECT count( distinct(rev_page)), count(*)
FROM revision
WHERE... |
1 year ago |
| SELECT count( distinct(rev_page)), count(*)
FROM revision
WHERE... |
1 year ago |
| SELECT count( distinct(rev_page)), count distinct(*)
FROM revision
WHERE... |
1 year ago |
| WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
| WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
| SELECT *
FROM page
WHERE page_id = 1950
|
1 year ago |
| WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
| WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
| WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
| WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
| SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
| SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
| SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
| SELECT count(distinct rev_page)# rev_page, substring(rev_timestamp, 1, 8)... |
1 year ago |
| SELECT count(distinct rev_page)# rev_page, substring(rev_timestamp, 1, 8)... |
1 year ago |
| SELECT count(*)# rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
| SELECT count(*)# rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
| SELECT count(*)# rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
|
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
| SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |
| #describe revision
SELECT count(*) count_rev, count(distinct(rev_page))
FROM... |
1 year ago |
| #describe revision
SELECT count(*) count_rev
FROM revision
WHERE... |
1 year ago |
| #describe revision
SELECT count(*) count_rev
FROM revision
WHERE... |
1 year ago |
| #describe revision
SELECT count(*) count_rev
FROM revision
WHERE... |
1 year ago |
| describe revision
|
1 year ago |
| show tables |
1 year ago |
