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

3 votes138 views2 answers
Count how many vowels in a string python
Python
1 vote148 views2 answers
How to get user id django
Python
0 vote142 views1 answer
Pygame mixer channel loop
Python
19 votes146 views3 answers
How to delete a column from a dataframe in python
Python
0 vote132 views1 answer
Python - remove columns with same name and keep first
Python
2 votes136 views2 answers
How to get key of a particular value in dictionary python using index
Python
0 vote151 views1 answer
Flipping an image with cv2
Python
0 vote136 views1 answer
Fnd closest element in array numpy
Python
0 vote140 views9 answers
Convert c++ to python online
Python
2 votes126 views2 answers
Python fillna with mode
Python