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 vote191 views1 answer
Split a string by comma in python
Python
1 vote145 views1 answer
Python ignore return value
Python
0 vote212 views1 answer
Tuple plot python
Python
2 votes181 views1 answer
Public in python
Python
34 votes188 views5 answers
How to install tkinter
Python
2 votes184 views1 answer
Python download s3 image
Python
1 vote175 views1 answer
Pyo example
Python
10 votes222 views3 answers
Create a virtualenv python3
Python
1 vote184 views1 answer
Mean squared error python
Python
2 votes212 views2 answers
Super in django manager
Python Django