MySQL 5.1 trigger

Article View: pl.comp.bazy-danych

Article #183172

Back to pl.comp.bazy-danych Previous Next

#183172

From: CYSTERNA
Date: Fri, 26 Jun 2009 22:22

18 lines
1778 bytes

Mam tabele ANKIETY a w niej pola TRESC i DATA_DODANIA. Jak user
wypelnia ankiete to do bazki wysyłany jest SQL :

INSERT INT ANKIETY SET TRESC = 'costamcostam';

teraz chce napisac triggera który po INSERCIE wartości do pola tresc
zaktualizuje mu date dodania.
robie tak:

CREATE TRIGGER TR1 AFTER INSERT ON ANKIETY UPDATE ANKIETY SET
DATA_DODANIA = Now() where isnull(DATA_DODANIA);

i kurna nie działa. Czy da sie zupdateować triggerem pole w aktualnie
dodawanym rekordzie ?
Jak powinien wyglądać ten trigger?

podrawiam
cysterna

Technical Details

Message-ID: <c52a6be6-2ea8-4ff3-b8b9-7572cfb45a88@q37g2000vbi.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!feeder.erje.net!news2.arglkargh.de!news.n-ix.net!newsfeed.freenet.de!feeder.news-service.com!postnews.google.com!q37g2000vbi.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!feeder.erje.net!news2.arglkargh.de!news.n-ix.net!newsfeed.freenet.de!feeder.news-service.com!postnews.google.com!q37g2000vbi.googlegroups.com!not-for-mail
From: CYSTERNA <e.cysterna@wp.pl>
Newsgroups: pl.comp.bazy-danych
Subject: MySQL 5.1 trigger
Date: Fri, 26 Jun 2009 15:22:49 -0700 (PDT)
Organization: http://groups.google.com
Lines: 18
Message-ID: <c52a6be6-2ea8-4ff3-b8b9-7572cfb45a88@q37g2000vbi.googlegroups.com>
NNTP-Posting-Host: 83.143.44.11
Mime-Version: 1.0
X-Trace: posting.google.com 1246054975 19885 127.0.0.1 (26 Jun 2009 22:22:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 26 Jun 2009 22:22:55 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: q37g2000vbi.googlegroups.com; posting-host=83.143.44.11;  posting-account=Cb_a2AoAAAAaZeEkduw8LZGH8cpnR5e_
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6;  .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR  3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit