11.06.2018, 18:56
(
Последний раз редактировалось Robin96; 12.06.2018 в 12:06.
)
Thank you! I am going to handle it that way.
Is there any way to get data out of the row that was affected by the UPDATE statement? In this particular case I am trying to do the following:
- Admin uses command to offline ban a player
- Update statement to be executed, if succesful the player is banned
- IP address and primary key of the affected player should be retrieved
- The IP address and primary key is to be used in 2 additional INSERT statements
Can I fetch the data of the affected row or should I execute a new SELECT statement?
Is there any way to get data out of the row that was affected by the UPDATE statement? In this particular case I am trying to do the following:
- Admin uses command to offline ban a player
- Update statement to be executed, if succesful the player is banned
- IP address and primary key of the affected player should be retrieved
- The IP address and primary key is to be used in 2 additional INSERT statements
Can I fetch the data of the affected row or should I execute a new SELECT statement?