Guest User

Untitled

a guest
Jan 19th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. REATE TABLE t_testblob (
  2. filename VARCHAR2(30) DEFAULT NULL NULL,
  3. apkdata BLOB NULL
  4. )
  5.  
  6. INSERT INTO table_name VALUES (memberlist,?,memberlist)
  7. UPDATE table_name SET ImageFieldName = ? WHERE ID=yourId
  8.  
  9. cursor = connection.cursor()
  10. for txt in ('a', 'b', 'c'):
  11. cursor.execute('SELECT * FROM test WHERE txt=?', (txt,))
  12.  
  13. cursor.execute("INSERT INTO t_testblob (filename, apkdata) VALUE (?, ?)", filename, my_binary_data)
Add Comment
Please, Sign In to add comment