Breaking News: Grepper is joining You.com. Read the official announcement!

mysql store numpy array

Friendly Hawk answered on April 16, 2021 Popularity 6/10 Helpfulness 4/10

answer mysql store numpy array

mysql store numpy array

Comment

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)

Popularity 6/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: mysql numpy python store

Link to this answer
Share Copy Link

Contributed on Apr 16 2021

Friendly Hawk

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

mysql store numpy array

Contents

More Related Answers

mysql store numpy array

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.