0

Is it possible to write a "SINGLE QUERY", by which i can delete row by id and get the name of deleted row. For example: I have a table

id | Name
------------
1  | ABC
2  | DEF
3  | GIH
4  | JKL

Edit: My question is not duplicate of this. I am again mentioning, I am trying to write "SINGLE QUERY".

Pramod Yadav
  • 245
  • 2
  • 20
  • @MadhurBhaiya, hello madhur bhaiya, I am searching for single query, if its possible – Pramod Yadav Sep 06 '19 at 12:36
  • 1
    Short answer: No. – Madhur Bhaiya Sep 06 '19 at 12:37
  • 1
    *"Edit: My question is not duplicate of this. I am again mentioning, I am trying to write "SINGLE QUERY"."* Long answer to add to @MadhurBhaiya 's comment .. You will have to program your own [MySQL Server Plugin](https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html) to extend default execution then you can do it in one query.. – Raymond Nijland Sep 06 '19 at 14:26
  • @RaymondNijland thanks for your valuable guidance. – Pramod Yadav Sep 06 '19 at 17:15

0 Answers0