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 vote145 views2 answers
Sns histplot change legend labels
Python
2 votes150 views1 answer
How to represent equation in Pytho
Python
0 vote151 views1 answer
Signup
Python
0 vote159 views1 answer
How to use assert in python
Python
1 vote155 views1 answer
Update set python
Python
0 vote161 views1 answer
Python chatbot error
Python
1 vote146 views1 answer
Pandas join series
Python
0 vote149 views1 answer
Sumif in python on a column and create new column
Python
1 vote149 views1 answer
Extend stack python
Python
0 vote142 views1 answer
How to bold in colorama
Python