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

5 votes146 views1 answer
UnicodeDecodeError: 'charmap' codec can't decode byte 0x9e in position 3359: character maps to <undefined>
Python
3 votes123 views2 answers
How many columns have null values present in them? in pandas
Python
1 vote131 views1 answer
Grouping products for sales
Python
13 votes136 views6 answers
Remove special characters from string python
Python
8 votes143 views4 answers
Zip a directory in python
Python
0 vote129 views1 answer
Sys.path[0]
Python
0 vote120 views2 answers
Pandas agg rename columns
Python
0 vote146 views1 answer
Local to ISO 8601 without microsecond:
Python
0 vote136 views1 answer
Smallest program to make diamond python
Python
1 vote145 views1 answer
Extract images from mp4 python
Python