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

6 votes205 views1 answer
Django model form
Python
1 vote190 views1 answer
Python remove non empty read only directory
Python
0 vote218 views1 answer
Main() invalid syntax
Python
7 votes254 views4 answers
Modules in python
Python
1 vote199 views1 answer
Python find string in list
Python
-1 vote206 views1 answer
Python graphql client
Python
0 vote212 views1 answer
Matplotlib set dpi 300
Python
0 vote190 views1 answer
Ya mom
Python
0 vote393 views5 answers
Django-tool-bar
Python Django
28 votes187 views2 answers
Making your own range function with step in python
Python