Skip to content

Instantly share code, notes, and snippets.

@tell-k

tell-k/gist:3722704

Created September 14, 2012 15:36
Download ZIP

Revisions

  1. tell-k revised this gist Sep 14, 2012. 1 changed file with 11 additions and 2 deletions.
    13 changes: 11 additions & 2 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1,2 +1,11 @@
    SELECT * FROM entries WHERE entries.id = 1 LIMIT 1
    UPDATE entries SET text="hogehoge" WHERE entries.id = 1
    INSERT INTO entries (id, text, created_at) VALUES (%s, %s, %s)
    (1, 'entrytext1', datetime.datetime(2012, 9, 15, 0, 39, 7, 668106))

    SELECT entries.id AS entries_id, entries.text AS entries_text, entries.created_at AS entries_created_at
    FROM entries
    WHERE entries.id = %s
    LIMIT %s
    (1, 1)

    UPDATE entries SET text=%s WHERE entries.id = %s
    ('hogehoge', 1L)
  2. tell-k created this gist Sep 14, 2012.
    2 changes: 2 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,2 @@
    SELECT * FROM entries WHERE entries.id = 1 LIMIT 1
    UPDATE entries SET text="hogehoge" WHERE entries.id = 1