I have typed query
UPDATE data SET data.numberOfSentMessages = data.numberOfSentMessages +1 WHERE data.id = :id
I need to know what is numberOfSentMessages after update. How can I get it?
Asked
Active
Viewed 48 times
1
Youcef LAIDANI
- 55,661
- 15
- 90
- 140
A.Sidor
- 257
- 4
- 12
-
What about a new query after the Update `SELECT d.numberOfSentMessages FROM data d WHERE d.id = :id` – Youcef LAIDANI Aug 01 '18 at 10:17
-
I would like to have everything from one query – A.Sidor Aug 01 '18 at 10:23
-
Can't you create a stored procedure, see https://stackoverflow.com/questions/24691576/mysql-update-column-then-select-updated-value – Joakim Danielson Aug 01 '18 at 10:27
-
It is what I wanted, thank you! – A.Sidor Aug 01 '18 at 10:48