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

2 votes111 views1 answer
Python numba
Python
1 vote105 views2 answers
Normalize = true pandas
Python
0 vote140 views1 answer
Remove base from terminal anaconda
Python
0 vote73 views1 answer
Cx_freeze include images in specific path
Python
0 vote107 views1 answer
Python function pointer with multiple args
Python
1 vote112 views1 answer
Python text to speech version 3
Python
1 vote117 views1 answer
How to delete print statement from console pythonn
Python
0 vote109 views1 answer
Numpy combine two arrays selecting min
Python
1 vote113 views1 answer
How to smooth a function in python
Python
0 vote72 views1 answer
There is no difference in R between a string scalar and a vector of strings
Python