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

12 votes202 views6 answers
Python flask
Python
0 vote180 views4 answers
Roobet crash bot
Python
0 vote293 views1 answer
Django clodinarystorage
Python Django
0 vote175 views1 answer
Algebraic pyramid python
Python
0 vote252 views2 answers
Fibbonachi python
Python
15 votes122 views2 answers
Is_integer() python
Python
0 vote178 views1 answer
Cos inverse in python numpy
Python
11 votes240 views10 answers
Python print
Python
0 vote167 views1 answer
Captions overlap in seaborn plot jupyter
Python
0 vote181 views2 answers
3D data visualization Python
Python