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

-2 votes104 views1 answer
Formatting time in python
Python
3 votes96 views3 answers
NameError: name ‘pd’ is not defined
Python
7 votes98 views1 answer
Import excel file to python
Python
10 votes117 views3 answers
Python dataframe find no of true
Python
0 vote105 views1 answer
Unittest sleep
Python
58 votes175 views6 answers
Python class
Python
0 vote95 views1 answer
Run django localhost server
Python
0 vote345 views1 answer
Create a file in a specific directory
Python
0 vote121 views1 answer
How to add column to heroku postgres in my django app
Python Django
0 vote93 views1 answer
Alternatives for appending to numpy array
Python