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 vote139 views1 answer
How to update image in django
Python Django
1 vote122 views1 answer
Python snakes
Python
16 votes119 views6 answers
Timestamp to date python
Python
0 vote116 views1 answer
Smart Weather Information App Using Python
Python
0 vote106 views1 answer
Django Abstract base classe
Python
1 vote112 views2 answers
How to convert datetime to integer in python
Python
1 vote110 views2 answers
Factors addition in pyhone
Python
1 vote101 views1 answer
Python close all plot figures
Python
2 votes108 views2 answers
Python program for geometric progression
Python
0 vote105 views1 answer
Python replace two spaces with one
Python