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

1 vote268 views1 answer
Mean squared error python
Python
268 votes367 views0 answer
Last element of list python
Python
7 votes253 views2 answers
How to get the remainder in python
Python
108 votes185 views17 answers
Conda environment setup
Python
2 votes277 views2 answers
Python - Count the Number of Keys in a Python Dictionary
Python
0 vote221 views1 answer
Left rotation in list
Python
67 votes262 views4 answers
How to know the version of python using cmd
Python
1 vote284 views1 answer
Python permission denied
Python
0 vote243 views1 answer
Np arange shape
Python
1 vote297 views1 answer
Difference between get and filter in django
Python Django