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 vote169 views1 answer
How to get device hwid cmd
Python
1 vote162 views1 answer
Grouping products for sales
Python
1 vote188 views1 answer
Django celery results
Python Django
1 vote172 views1 answer
How to get location of word in list in python
Python
0 vote170 views1 answer
Onetoone vs foreign key django
Python
5 votes151 views3 answers
Python add
Python
2 votes161 views2 answers
How to exit the program in pygame
Python
8 votes156 views2 answers
Jupyter read excel
Python
5 votes165 views3 answers
Get last day of month python
Python
0 vote179 views1 answer
How to use iteration in python
Python