Skip to content

Instantly share code, notes, and snippets.

@tell-k
Created September 14, 2012 15:36
Show Gist options
  • Save tell-k/3722704 to your computer and use it in GitHub Desktop.
Save tell-k/3722704 to your computer and use it in GitHub Desktop.
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment