SQL Logging - Log Delete Results Too?
| User, date | Message |
|---|---|
|
Written by muzza4
5 years ago Category: General 50 posts since Mon, 04 Dec 06 |
Hi Anse, With logging turned on we see in the log Update Example --------------------- [2007-12-21 10:36:25] UPDATE `noticeboard` SET `header`='Test Message',`displayTo`='2006-12-09 12:55:00',`deleted`='Y',`created`='2006-10-10 01:55:18',`created_by`='2' WHERE `Id`=188 Insert Example ------------------------ [2007-12-21 10:42:57] INSERT INTO `clubsport` (`Id`, `club_id`, `sport_id`, `federation_club_id`) VALUES (1,1,1,0), (2,2,1,0), (3,3,1,0), (4,11,1,0), (5,12,1,0), (7,14,1,0), (17,38,1,0), (22,74,1,0), (40,101,1,0), (41,103,2,0), (42,104,1,0), (67,108,1,0), (68,109,1,0), (69,110,1,0), (94,116,1,0), (96,118,1,0), (99,122,1,0), (149,13,1,0), (150,15,1,0), (151,16,1,0), (152,17,1,0), (153,18,1,0), (154,19,1,0), (155,20,1,0), (156,22,1,0), (157,28,1,0), (158,29,2,0), (159,49,2,0), (160,50,2,0), (167,130,1,0), (172,135,1,0) Delete Example -------------------------- [2007-12-21 10:42:53] delete from clubsport Why does the delete not show what was deleted, the updates and inserts give an excellent log. Regards Muzza |
|
Written by ansgar
5 years ago 3977 posts since Fri, 07 Apr 06 |
Oh DELETEs also get into the log as you expect. This DELETE command was surely not executed while you were deleting a row from a grid view, probably you executed it by query or by rightclicking a table and then clicking "Empty..." |
|
Please login to leave a reply, or register at first. |