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 vote225 views1 answer
Small Python Game
Python
1 vote241 views3 answers
Link in embed discord.py
Python
2 votes229 views1 answer
Python loop append to dictionary
Python
0 vote223 views1 answer
Sort list in python by substring
Python
11 votes234 views4 answers
Append dataframe to another dataframe
Python
0 vote216 views1 answer
Repeat a condition n times one by one python
Python
8 votes249 views4 answers
Python list prime numbers
Python
0 vote237 views1 answer
Python split() source code
Python
0 vote252 views1 answer
Installing intel python
Python
4 votes239 views1 answer
Convert string array to integer python
Python