add and remove data of mysql

[kevin_sadoun]

dear all,

I can't add and remove data in my database. 

I create my SQL request but I don't know how to run it directly in alteryx. 

in attachment you have the picture of the workflow, the zoom of error, the configuration of my tools and message error

maybe there are another solution but I don't find it

[MichalM · Accepted solution]

My suspicion is that the user doesn't have write access to the location where the temporary table is being created. This is normally defined within the driver we use to talk to the database - normally appears as 'Default Database' setting depending on database you're using. 

[kevin_sadoun]

it's working thank's a lot.