[SQLite] Deleted rows count
#2

You could use
pawn Код:
SELECT changes()
to return the recent changes in your database

For example this is your database structure.
pawn Код:
-> table_name
- row 1 ->
- row 2 ->
- row 3 ->
- row 4 ->
- row 5 ->
- row 6 ->

All rows with the name of 'Patrick'
then you run a query
pawn Код:
DELETE FROM table_name WHERE username = 'Patrick'
then you run the changes() function, which will return the number of rows that has been deleted.
Reply


Messages In This Thread
[SQLite] Deleted rows count - by Jefff - 26.10.2017, 23:36
Re: [SQLite] Deleted rows count - by PatrickGTR - 26.10.2017, 23:59
Re: [SQLite] Deleted rows count - by Jefff - 27.10.2017, 00:21
Re: [SQLite] Deleted rows count - by PatrickGTR - 27.10.2017, 00:26
Re: [SQLite] Deleted rows count - by Jefff - 27.10.2017, 01:24

Forum Jump:


Users browsing this thread: 1 Guest(s)