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 vote165 views1 answer
Python recognize every white color
Python
0 vote174 views2 answers
Google.protobuf.Struct example python
Python
0 vote145 views1 answer
Couple legend from twin axes python
Python
0 vote163 views1 answer
Pong code python
Python
2 votes158 views1 answer
Making lists with loops in one line python
Python
7 votes168 views6 answers
Dictionary comprehension python
Python
3 votes157 views2 answers
Multiply all values in column pandas
Python
0 vote146 views1 answer
Size.width>0 && size.height>0 in function 'cv::imshow'
Python
0 vote143 views1 answer
Limit of list in python
Python
0 vote156 views1 answer
Python get text of QLineEdit
Python