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 vote206 views1 answer
Gpg --verify Python-3.6.2.tgz.asc
Python
1 vote182 views1 answer
Message tags in django
Python
0 vote249 views1 answer
Flask return 404
Python Flask
1 vote219 views1 answer
How to get continuous mouse position with pyautogui in python
Python
1 vote266 views1 answer
How to custom page not found in django
Python Django
53 votes179 views2 answers
Python get element by index
Python
2 votes172 views1 answer
Python get all methods of object
Python
-1 vote180 views1 answer
ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\__init__.py)
Python
1 vote213 views1 answer
How to open sound file in python
Python
12 votes207 views2 answers
Python pip version check
Python