Team,

Please guide me with the option of rollback query in case a secondary query fails and I need to rollback the first query.

You're best to use Transactions for this sort of thing

Thanks for the reply.

Can you please post a link from where I can use transactions?

There are many examples you can find with Google or YouTube.

Here's a good one to start with

https://www.mysqltutorial.org/mysql-transaction.aspx