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 vote221 views1 answer
Matplotlib show two distinct plots
Python
0 vote229 views2 answers
Days in month function python
Python
0 vote225 views2 answers
Check if set is a subset of another python
Python
1 vote219 views1 answer
Append method linked list python
Python
0 vote216 views1 answer
How to import the whall library in python
Python
0 vote230 views1 answer
Cmap perlin noise python
Python
2 votes196 views1 answer
Python unchain list
Python
0 vote237 views1 answer
Left fill with zeros
Python
2 votes211 views1 answer
Python selenium move cursor to element
Python
5 votes191 views1 answer
If string include word in list
Python