update and delete with one where clause in sql

i have a query written in MySQL and I use an update and delete both in query with 2 where clause but i want only 1 where clause

here is my query

UPDATE ctrData2.WrapupCodes      SET CategoryId=null where CategoryId=6; delete from ctrData2.Category where CategoryId=6 

can i use just 1 where clause in this query if yes So, please show me how

Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.