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 vote98 views2 answers
Foreign key and primary key difference
Python
0 vote112 views1 answer
Missing number
Python
0 vote93 views1 answer
Pd calculations between columns
Python
0 vote99 views1 answer
Pyspark concat columns
Python
1 vote109 views5 answers
How to install django in virtual environment in ubuntu
Python
0 vote116 views1 answer
How to get max id in mongodb python
Python
0 vote110 views1 answer
Import all models
Python
0 vote102 views2 answers
Fibonacci sequence algorithm python
Python
2 votes102 views3 answers
Insert numpy array to column
Python
0 vote97 views1 answer
Pandas csv sum column
Python