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 vote366 views2 answers
Numpy nditer
Python
29 votes346 views5 answers
Python date and time
Python
0 vote330 views1 answer
Intialising a tuple in python
Python
0 vote342 views1 answer
Ascii tables in python
Python
0 vote322 views1 answer
Pyspark read from redshift
Python
7 votes359 views3 answers
Get file extension python
Python
0 vote350 views4 answers
How to open a dataset in netcdf4
Python
0 vote348 views1 answer
Numpy diff
Python
2 votes334 views2 answers
Install python3.7 ubuntu 20.04
Python
3 votes326 views1 answer
Tkinter widget span multiple colums
Python