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

1 vote288 views1 answer
Create dataframe from csv and name columns pandas
Python
23 votes307 views5 answers
Change string list to int list python
Python
0 vote325 views1 answer
Lines = paths.read().splitlines()
Python
0 vote355 views1 answer
Q fields django Q objects
Python Django
2 votes352 views3 answers
Python pywin32 get current cursor row
Python
0 vote355 views1 answer
Django BruteBuster error failed attempts
Python Django
0 vote336 views1 answer
Equal Sides Of An Array python
Python
0 vote321 views1 answer
No module named cbor2 windows
Python
15 votes336 views2 answers
Loop throughthe key and the values of a dict in python
Python
0 vote327 views1 answer
Show battery of my laptop python
Python