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

1 vote262 views1 answer
The operands of the logical operators should be boolean expressions, but python is not very strict. any nonzero number is interpreted as true.
Python
5 votes241 views2 answers
Insert function in list
Python
0 vote258 views1 answer
How to install tkinter in pycharm
Python
1 vote254 views1 answer
Images subplot python
Python
0 vote234 views1 answer
Pip install mod_wsgi error
Python
0 vote265 views4 answers
Select series of columns
Python
1 vote243 views1 answer
Continue reading lines until there is no more input python
Python
2 votes239 views1 answer
Who is a pythonista
Python
0 vote257 views2 answers
Python find index of closest value in list
Python
0 vote255 views1 answer
Discord bot response to private message python
Python