CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Thu, 31 Jul 2025 06:58:08 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100614091808 location: https://web.archive.org/web/20100614091808/https://answers.oreilly.com/tag/triggers server-timing: captures_list;dur=0.707338, exclusion.robots;dur=0.027620, exclusion.robots.policy;dur=0.013595, esindex;dur=0.013259, cdx.remote;dur=9.564374, LoadShardBlock;dur=141.828056, PetaboxLoader3.datanode;dur=74.944024, PetaboxLoader3.resolve;dur=57.191981 x-app-server: wwwb-app204 x-ts: 302 x-tr: 179 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app204; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Thu, 31 Jul 2025 06:58:09 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Mon, 14 Jun 2010 09:18:07 GMT x-archive-orig-server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.8 x-archive-orig-x-powered-by: PHP/5.2.8 x-archive-orig-set-cookie: answers_session_id=deleted; expires=Sun, 14-Jun-2009 09:18:06 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Sun, 14-Jun-2009 09:18:06 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-cache-control: ,no-cachemust-revalidate, max-age=0 x-archive-orig-expires: 0 x-archive-orig-pragma: no-cache x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Mon, 14 Jun 2010 09:18:08 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Mon, 14 Jun 2010 09:18:08 GMT", ; rel="memento"; datetime="Mon, 14 Jun 2010 09:18:08 GMT", ; rel="next memento"; datetime="Sun, 15 Aug 2010 01:54:27 GMT", ; rel="last memento"; datetime="Sat, 07 Sep 2013 11:21:36 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 52_16_20100614073328_crawl102-c/52_16_20100614091656_crawl100.arc.gz server-timing: captures_list;dur=0.554501, exclusion.robots;dur=0.020673, exclusion.robots.policy;dur=0.009643, esindex;dur=0.011379, cdx.remote;dur=16.902447, LoadShardBlock;dur=203.738368, PetaboxLoader3.datanode;dur=106.692336, PetaboxLoader3.resolve;dur=119.151661, load_resource;dur=136.184572 x-app-server: wwwb-app204 x-ts: 200 x-tr: 463 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip triggers Questions and Answers - O'Reilly Answers

Jump to content

O'Reilly Answers

Clever Hacks. Creative Ideas. Innovative Solutions.

Share your knowledge

Welcome

Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback
Feed icon

O'Reilly Answers Feed
Twitter icon

@oreillyanswers

Topics: triggers

triggers Feed triggers Open Questions Feed triggers Email Open Questions via Email

How to use a trigger to log changes to a table in MySQL

By pauldubois : 14 September 2009 - 10:10 AM
If you have a table that maintains current values of items that you track (such as auctions being bid on), but you’d also like to maintain a journal (or history) of changes to...
Tags:
0Votes

0Comments
How to use a trigger to define dynamic default column values in MySQL

By pauldubois : 14 September 2009 - 09:46 AM
If a column in a table needs to be initialized to a nonconstant value, but MySQL allows only constant default values, use a BEFORE INSERT trigger. This e...
Tags:
0Votes

0Comments
How to create compound-statement objects in MySQL

By pauldubois : 14 September 2009 - 09:10 AM
If you want to define a stored routine, a trigger, or an event, but its body contains instances of the ; statement terminator, redefine the mysql statement terminator w...
Tags:
0Votes

0Comments