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 vote215 views1 answer
Simplest flask memcached
Python
5 votes212 views3 answers
Get input from user in python
Python
0 vote217 views1 answer
Printing hollow triangle in python
Python
15 votes204 views6 answers
Django models
Python
2 votes204 views2 answers
Update python in miniconda
Python
1 vote197 views1 answer
Python requests.get pdf An appropriate representation of the requested resource could not be found
Python
0 vote224 views1 answer
How to do disconnect command on member in discord python
Python
12 votes203 views2 answers
Column.replace
Python
0 vote219 views1 answer
Run for loop inside pdb
Python
1 vote214 views1 answer
Python print string name in pattern
Python