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 vote168 views1 answer
Threshhold crossing on list python
Python
0 vote251 views1 answer
Superpixel
Python
0 vote181 views2 answers
Export keras model at specific epoch
Python
1 vote160 views1 answer
Load diamonds dataset from sns
Python
0 vote158 views1 answer
Python set workspace dir
Python
21 votes160 views2 answers
Plt import
Python
0 vote177 views1 answer
Kwargs handling multiple arguments and iterating them loop
Python
0 vote242 views2 answers
Count items in a model django rest
Python
0 vote222 views1 answer
How to get a user's avatar with their id in discord.py?
Python
0 vote163 views1 answer
How to create simple window in wxPython
Python