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

2 votes150 views2 answers
Python curses for windows
Python
0 vote177 views2 answers
Print specific key in dictionary python
Python
0 vote147 views1 answer
Python input timeout
Python
0 vote261 views2 answers
Pandas continues update csv
Python
7 votes133 views2 answers
Check if is the last element in list python
Python
2 votes142 views2 answers
Panda - subset based on column value
Python
6 votes199 views5 answers
Django logout
Python
0 vote136 views1 answer
Pip in vscode linux
Python
0 vote168 views1 answer
Python nasa api
Python
0 vote141 views1 answer
Text generate gpt 2 huggingface
Python