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 vote365 views1 answer
Sqlalchemy date beween
Python
0 vote393 views1 answer
LDB SHOP ROBOTIC TANK
Python
0 vote348 views1 answer
Df index start from 1
Python
0 vote385 views1 answer
Mak a scipy csr sparse matrix
Python
0 vote347 views1 answer
Python selenium not returning correct source
Python
5 votes345 views1 answer
Selenium webdriver imports
Python
0 vote369 views1 answer
Binarize array python
Python
0 vote326 views1 answer
Python socket set title
Python
0 vote362 views1 answer
Import math print(m.cos(10))
Python
0 vote357 views1 answer
Insurance= contract.x_studio_social_security_basic salary of ins = 1500 result = contract.x_studio_social_security_basic_salary*100
Python