How to use WHERE clause in Execute query for MYSQL correctly

database

#1

Hi i am trying to insert data into MYSQL DB and getting error when using WHERE clause can anyone help me in how to use where clause correctly in uipath.
currently getting error when using variable name

example “UPDATE orix_filelist SET Flag=1 WHERE Filename=”+filenamevar+""

When using UPDATE or select with where like this it is not giving error

example “UPDATE orix_filelist SET Flag=1 WHERE Flag=0”

Regards
nara


#2

Can you try this and let me know:

“UPDATE orix_filelist SET Flag=1 WHERE Filename=’”+filenamevar+’"


#3

Hi @Nara,

If you are using string variable, assuming from your variable name ‘filenamevar’ - u should add single quote.

“UPDATE orix_filelist SET Flag=1 WHERE Filename=’”+filenamevar+"’

Regards
Vitan


#4

Thank you @Vitan it worked correctly!!
Regards
Nara


#5

Thanx @aksh1yadav @Vitan solution worked for me

Regards
Nara


#6

Hi @aksh1yadav @Vitan,

Can anyone tell me how can i insert the data dynamically in my table.
It showing me error while i am performing the steps in uipath