update query is not working in 5.5 v

[Vajra]

UPDATE
accounts a, endpoints ep set a.status =
'SUSPENDED FROM IMPORT SERVICE' WHERE
a.endpointkey = ep.endpointkey and a.name like
'%-Deleted%' and ep.endpointname='Duo_MFA';

the error is ERROR - Custom Query Job could not be executed -
Query contains Delete, Truncate, DROP,
FOREIGN_KEY_CHECKS which are not allowed-UPDATE
accounts a, endpoints ep set a.status =
'SUSPENDED FROM IMPORT SERVICE' WHERE
a.endpointkey = ep.endpointkey and a.name like
'%-Deleted%' and ep.endpointname='Duo_MFA';

Expecting quick responses

[This message has been edited by moderator to merge reply comment content]

[dgandhi]

Try below and check?

update saviynt.accounts a
join saviynt.endpoints ep on
a.endpointkey=ep.endpointkey
set a.status='SUSPENDED FROM IMPORT SERVICE'
where a.name like '%-Deleted%' and ep.endpointname='Duo_MFA'

[rushikeshvartak]

UPDATE
accounts a, endpoints ep set a.status =
'SUSPENDED FROM IMPORT SERVICE' WHERE
a.endpointkey = ep.endpointkey and a.name like
'%-Deletd%' and ep.endpointname='Duo_MFA';

Avoid Query containing keywords such as Delete, Truncate, DROP.

[Darshanjain]

Hi @Vajra 

Please dont use Delete, Truncate, DROP  in the update queries, instead of those u can do aviod those exact words like Del% or Dro% in the query which should work.

Thanks

Darshan

[Vajra]

infact i have used the below it was not working 

UPDATE
accounts a, endpoints ep set a.status =
'SUSPENDED FROM IMPORT SERVICE' WHERE
a.endpointkey = ep.endpointkey and a.status=2
 and ep.endpointname='Duo_MFA';

However this was also working . is there any restriction that we cannot use the status attribute??

[Darshanjain]

What is the error you are getting, its working fine from my end.

Thanks

Darshan