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 vote204 views1 answer
Python save base64 temp file
Python
1 vote198 views2 answers
Getting player input python
Python
2 votes262 views2 answers
How to get only first record in django
Python Django
1 vote221 views2 answers
Debugar python
Python
0 vote197 views1 answer
How to change size of turtle in python
Python
0 vote203 views1 answer
Holding a function to the code in python
Python
6 votes201 views3 answers
How do i get parent directory python
Python
2 votes211 views2 answers
How to make a clock in python 3
Python
0 vote275 views1 answer
Hover 777-286
Python
2 votes276 views1 answer
How to open file dialog in pytohn
Python