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 vote151 views1 answer
Binary to decimal python
Python
0 vote166 views1 answer
How to count the appearance of number or string in a list python
Python
1 vote162 views4 answers
Python 2.7 venv
Python
1 vote149 views1 answer
Python dict to url params
Python
0 vote155 views1 answer
Python how to make multiple box plots
Python
0 vote153 views1 answer
Pandas not a time nat
Python
0 vote219 views1 answer
Txt file duplicate line remover python
Python
0 vote153 views1 answer
Task orchestration framework
Python
1 vote152 views1 answer
Fake migration
Python
0 vote159 views1 answer
Split custom pytorch dataset
Python