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 votes332 views2 answers
Search in django
Python Django
25 votes329 views6 answers
Pandas select row by index
Python
0 vote425 views1 answer
How to deploy to heroku djangorest framework app
Python Django
0 vote323 views1 answer
Python elementtree load from string
Python
5 votes311 views1 answer
Rectangle in tkinter
Python
2 votes332 views6 answers
How to setup Turtle python
Python
0 vote330 views1 answer
Python to c++ compiler
Python
1 vote391 views1 answer
Join function
Python
2 votes333 views1 answer
How to make python3.9 active
Python
0 vote333 views1 answer
Compute difference of all the combinations of 2 arrays
Python