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

1 vote176 views1 answer
Convert negative to zero in list in python
Python
18 votes188 views5 answers
Continue statement in python
Python
0 vote136 views1 answer
Exercism phone number python
Python
1 vote178 views2 answers
Subtract from dataframe column
Python
32 votes164 views4 answers
Clipboard python
Python
1 vote168 views2 answers
Max float python
Python
3 votes183 views3 answers
Python find file name
Python
3 votes180 views2 answers
Thread with args python
Python
3 votes183 views5 answers
Python get attributes of object
Python
0 vote176 views1 answer
Python pseudocode functions
Python