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

18 votes264 views2 answers
Open an exe file using python
Python
0 vote287 views1 answer
Alan watts
Python
0 vote259 views2 answers
Python int string float
Python
2 votes248 views2 answers
Get a liste from a txt file python
Python
0 vote244 views1 answer
Txt file duplicate line remover python
Python
0 vote286 views1 answer
Django admin.py date format
Python Django
2 votes248 views1 answer
Python hashlib.sha512()
Python
1 vote234 views1 answer
Np.rand.randint
Python
1 vote262 views1 answer
Python eval set variable
Python
0 vote253 views1 answer
Set_interval()
Python