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 vote98 views1 answer
56
Python
0 vote140 views1 answer
How to import something in python
Python
0 vote150 views1 answer
Remove prefix in python 3.6
Python
0 vote153 views1 answer
Sort first element reverse sort second python
Python
0 vote146 views1 answer
Pylatex add section without numbering
Python
7 votes129 views1 answer
First position dict python
Python
0 vote242 views1 answer
Merge two query sets django
Python Django
2 votes140 views2 answers
Iterrows pd
Python
17 votes135 views3 answers
Change column names with number pd dataframe
Python
3 votes137 views2 answers
Python split by first match
Python