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 vote258 views1 answer
Python print os command output -1
Python
7 votes262 views2 answers
What is numpy
Python
2 votes227 views2 answers
Int' object is not subscriptable in python
Python
2 votes284 views2 answers
List of seaborn color palette
Python
2 votes269 views3 answers
Fibonacci series python using function
Python
0 vote276 views1 answer
52277-36880
Python
58 votes352 views6 answers
Python class
Python
21 votes269 views1 answer
Python slice an array
Python
0 vote271 views1 answer
Tf.data.Dataset select files with labels filter
Python
12 votes250 views2 answers
Python sort array of dictionary by value
Python