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 vote291 views1 answer
How to find how many processors you have with python
Python
2 votes322 views1 answer
Clone website
Python
0 vote330 views1 answer
Python csv reader cast to float
Python
1 vote294 views1 answer
Python all letters capital
Python
1 vote301 views1 answer
Print every element in list python outside string
Python
0 vote338 views1 answer
Python zip folder and subfolders
Python
44 votes308 views3 answers
How can I sort a dictionary in python according to its values?
Python
0 vote316 views1 answer
Opencv write text
Python
2 votes312 views1 answer
MAPE python
Python
1 vote344 views4 answers
Join tables in django orm
Python