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

17 votes194 views4 answers
How to check how many items are in a list python
Python
0 vote173 views1 answer
Django model custom field
Python
0 vote165 views1 answer
Python slack webhook
Python
0 vote169 views1 answer
Spacy Vietnamese
Python
68 votes201 views4 answers
How to define main in python
Python
2 votes202 views2 answers
How to open a website with selenium python
Python
2 votes167 views1 answer
Python random date between range
Python
0 vote175 views1 answer
Optimize images in python using pillow
Python
0 vote153 views1 answer
Dataclass in python
Python
2 votes181 views1 answer
Make new dataframe from slice
Python