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 vote319 views1 answer
Django nested inlines
Python
1 vote314 views1 answer
Use incognito mode in selenium
Python
5 votes302 views1 answer
Python flask query params
Python
-1 vote282 views1 answer
How to make an action repeat in python
Python
0 vote311 views1 answer
Python image layers
Python
-1 vote333 views2 answers
Python timestamp to yyyy-mm-dd
Python
39 votes282 views5 answers
How to calculate the sum of a list in python
Python
3 votes298 views2 answers
List of dictionary values
Python
0 vote293 views1 answer
Else if in django template
Python
-1 vote278 views1 answer
Print "hi"
Python