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 vote163 views1 answer
How do you say not equal to python
Python
0 vote119 views1 answer
Difference in django project view and app view
Python
23 votes141 views1 answer
How to extract month from date in python
Python
0 vote124 views1 answer
Cursor.fetchall() to list
Python
6 votes128 views1 answer
Gtts
Python
1 vote115 views1 answer
Robot framework log from python
Python
1 vote135 views1 answer
How to aggregate multiple columns in pyspark
Python
0 vote141 views1 answer
Python program to calculate area of a rectangle using function
Python
0 vote141 views1 answer
With torch.no_grad() if condition
Python
0 vote121 views1 answer
Python message from teams
Python