Shulou(Shulou.com)06/01 Report--

This article mainly introduces how myBatis query before / after insertion to obtain the value of a field, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Query to get the value of a field before / after insertion and use it in the second sql immediately following

Select COALESCE (max (top_sort), 0) + 1 from table update tabletop_sort = # {top_sort}, update_time=# {update_time}, update_user=# {update_user} where id = # {id} Thank you for reading this article carefully. I hope the article "how to query myBatis to get the value of a field before / after insertion" shared by the editor is helpful to you. At the same time, I hope you will support it. Pay attention to the industry information channel, more related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.