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 vote146 views1 answer
Urllib.error.HTTPError: HTTP Error 403: Forbidden
Python
-1 vote158 views2 answers
Dataframe multiindex
Python
0 vote182 views1 answer
A int and float python
Python
0 vote161 views1 answer
Python split files into even sets of folders
Python
0 vote154 views1 answer
Create New spreadsheet
Python
1 vote142 views1 answer
Pandas dataframe lists as columns
Python
2 votes133 views2 answers
Python literal string
Python
-1 vote146 views2 answers
Pandas df exact equals
Python
1 vote150 views1 answer
How to veiw and edit files with python
Python
16 votes140 views1 answer
Python reload function in shell
Python