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 vote204 views1 answer
Cryptography 'openssl/opensslv.h' file not found
Python
1 vote187 views1 answer
Spress warnings selenium python
Python
2 votes188 views2 answers
Install curses python
Python
0 vote210 views1 answer
(for in) printing in python
Python
0 vote215 views1 answer
Is python3 enough for react native
Python
0 vote224 views1 answer
Django queryset to instance
Python Django
0 vote203 views1 answer
Numpy declare arraylength
Python
1 vote221 views1 answer
How to add new cell in jupyter notebook
Python
0 vote187 views1 answer
Multipart/form data multipart encoder python
Python
1 vote185 views1 answer
Accuracy score sklearn syntax
Python