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

5 votes299 views6 answers
Pytube python
Python
0 vote310 views2 answers
How to convert string labels to numpy array
Python
6 votes298 views2 answers
Python datetime get all days between two dates
Python
1 vote305 views1 answer
Install imageio
Python
1 vote301 views1 answer
Python añadir elementos a una lista
Python
1 vote321 views1 answer
How to get files list from active directory from where the python script is running
Python
0 vote300 views1 answer
Install python setuptools ubuntu
Python
1 vote315 views1 answer
Polynomial features random forest classifier
Python
32 votes312 views4 answers
Copy to clipboard python
Python
0 vote308 views1 answer
Read excel formula value python openpyxl
Python