Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- def main():
- conn = mysql.connector.connect(user='root',
- password='',
- host='127.0.0.1',
- database='isubata')
- cur = conn.cursor()
- sql = "select name,data from image"
- cur.execute(sql)
- row = cur.fetchall()
- fname = row[0::2]
- fdata = row[1::2]
- num_of_file = len(fdata)
- for i in range(num_of_file):
- f = open(fname[i], 'wb')
- f.write(fdata[i])
- f.close()
- if __name__ == '__main__':
- main()
Add Comment
Please, Sign In to add comment