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 vote119 views1 answer
Swap two lists without using third variable python
Python
6 votes158 views4 answers
Install python3 in ubuntu
Python
1 vote121 views1 answer
Libreoffice add line in table
Python
-1 vote121 views4 answers
Python sort string
Python
0 vote159 views1 answer
Django content type for model
Python Django
0 vote142 views1 answer
Check if host is reachable python
Python
12 votes150 views5 answers
Append python
Python
6 votes123 views2 answers
How to find index of maximum value in dataframe in python
Python
6 votes115 views1 answer
How to set the icon of the window in pygame
Python
7 votes116 views2 answers
Python pretty print
Python