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

45 votes352 views6 answers
Get files in directory python
Python
11 votes326 views3 answers
Get yesterday date python
Python
6 votes314 views1 answer
Python merge two array into one
Python
0 vote344 views1 answer
Use get method request html page python
Python
3 votes335 views2 answers
Change django administration text
Python
0 vote311 views1 answer
Hostname python
Python
2 votes314 views1 answer
Python calculate time taken
Python
0 vote307 views2 answers
Keras name layers
Python
0 vote320 views1 answer
Python execute echo to file
Python
52 votes332 views2 answers
Index in list
Python