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

7 votes297 views5 answers
Convert categorical variable to numeric python
Python
0 vote285 views1 answer
Check if digit or alphabet
Python
8 votes236 views2 answers
Leap year algorithm
Python
35 votes260 views4 answers
Creating python classes
Python
10 votes261 views1 answer
Enumerate zip python
Python
0 vote249 views1 answer
Modulenotfounderror: no module named 'flask_jwt_extended'
Python
3 votes260 views1 answer
Python procedured
Python
0 vote284 views2 answers
Problem 1 dot product python
Python
6 votes242 views1 answer
Looking through an array in python
Python
2 votes266 views2 answers
Python how to get script directory
Python