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

config db-in.PNG

error message.PNG

worflow globa.PNG

workflow zoom.PNG

MichalM

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.