Skip to content

Instantly share code, notes, and snippets.

@halfak

halfak/gist:638a70f78046c0770a0b

Created September 18, 2014 14:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save halfak/638a70f78046c0770a0b to your computer and use it in GitHub Desktop.
Save halfak/638a70f78046c0770a0b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql:research@analytics-store.eqiad.wmnet [staging]> CREATE UNIQUE INDEX wiki_rev_id ON events_sandbox_edit (wiki, rev_id);
ERROR 1062 (23000): Duplicate entry 'enwiki-625851283' for key 'wiki_rev_id'
mysql:research@analytics-store.eqiad.wmnet [staging]> select * from events_sandbox_edit where wiki = "enwiki" and rev_id = 625851283;
+--------+-----------+----------------+----------+---------------+----------------+------------------+
| wiki | rev_id | rev_timestamp | rev_user | rev_user_text | page_namespace | page_title |
+--------+-----------+----------------+----------+---------------+----------------+------------------+
| enwiki | 625851283 | 20140916191849 | 22216559 | Olive875 | 2 | Olive875/sandbox |
+--------+-----------+----------------+----------+---------------+----------------+------------------+
1 row in set (1.36 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment