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 vote216 views1 answer
Earthpy
Python
-1 vote182 views1 answer
Add border to table in python pptx
Python
1 vote191 views1 answer
Pandas multiple string contains
Python
1 vote239 views1 answer
Django filter after annotate
Python Django
0 vote224 views1 answer
How to show a frequency distribution based on date in python
Python
0 vote198 views1 answer
---Input Chevy Times---
Python
5 votes183 views2 answers
Python how to put int into list
Python
1 vote182 views1 answer
Pd combine series
Python
1 vote205 views1 answer
Time date in pandas to csv file
Python
-2 votes194 views1 answer
Create simple calculator in python
Python