Mysql store numpy array

myNumpyArray = np.random.rand((3,3))

#convert to list, then to string, then store as VARCHAR(20000) in mysql
numpyString = str(myNumpyArray.tolist()) 
query = "insert into mytable(mycolumn) VAlUES ('"+numpyString+"')"
cursor.execute(query)

#Note: to retreive from mysql,you can convert to array using eval:
#myArray = eval(mycolumn)

Similar codes

0 vote108 views1 answer
How to add column to heroku postgres in my django app
Python
1 vote136 views1 answer
Import status in django rest framework
Python Django
0 vote116 views1 answer
NotJSONError('Notebook does not appear to be JSON: \'\\ufeff{\\n "cells": [\\n {\\n "cell_typ...',)
Python
0 vote112 views2 answers
Python min value index from an array
Python
7 votes96 views5 answers
.format python 3
Python
0 vote114 views1 answer
Extract tgz files in python
Python
0 vote146 views1 answer
Send message if user is banned discord.py
Python
120 votes102 views6 answers
Getting Input in Python
Python
8 votes136 views1 answer
Find sum of 2 numbers in array using python
Python
4 votes165 views1 answer
Python django shell command
Python Django