MySQL Forums
Forum List  »  Triggers

Re: trigger to create a log file
Posted by: Roland Bouman
Date: February 07, 2006 07:22AM

Yes I know, sorry about that. The problem is the quote character, for several reasons, it's not a normal single quote but a symbol resembling it. It has got nothing to do wih the SQL, it's more a matter of rendering the code in a HTML page.

You should be alright for 90% once you replace each occurrence of

with
'

Beware that the article literally duplicates each table - a different architecture than yours. The article is meant to show you how it's done - it makes no guarantee you can actually use the code.

BTW, a slightly modified version of the article is available here:
http://quest-pipelines.com/newsletter-v6/1005_A.htm
this has got proper quotes. However that one uses CURRENT_USER to fill in the current user. THat should be SESSION_USER (see: http://www.futhark.ch/mysql/116.html and http://www.futhark.ch/mysql/123.html for more info on the user issue)

Options: ReplyQuote


Subject
Views
Written By
Posted
16191
February 06, 2006 04:14AM
8084
February 06, 2006 06:32PM
4405
February 07, 2006 04:15AM
4265
February 07, 2006 05:43AM
3705
February 07, 2006 07:06AM
Re: trigger to create a log file
3752
February 07, 2006 07:22AM
3357
February 07, 2006 10:28AM
3449
February 07, 2006 02:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.