On last.fm: Taylor Swift photos and free music!
BNET Business Network:
BNET
TechRepublic
ZDNet

FREE Registration is required

Overview:

In database terminology, a trigger is a stub of code that is automatically activated when a particular database event, such as an INSERT or DELETE, occurs. Triggers are handy for logging, to automatically "cascade" changes down from a single table to other linked tables, or to ensure that table relationships are automatically updated. Triggers are new in MySQL 5.x, and have been gradually improving as new versions of the 5.x code tree have emerged. In this download, you get a brief introduction to the uses of the database trigger, how to view trigger status, and how to delete a trigger once you're done with it. I'll also show you a common example of how triggers are used in the real world, to audit changes made to database records.

This download is also available as a TechRepublic article.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format:Other DownloadSize:40 KB
Date:Aug 2006Version:1.0
License:copyright
System Req:Acrobat Reader 5.0 or later and an unzipping app

People who downloaded this item also downloaded

Download 10 cool things you can do with a USB flash drive
Download 10 obscure Linux applications you need to try
Download 10+ IT pros share the utilities and tools they can't live without
Download Top 10 Windows XP tips of 2008
Download The 10 most useful Linux commands

Top results from Linux - Open Source

Webcast Invest in Smarter Collaboration - Early Benefits of Enterprise Social Software
White Paper 10 Red Hat Linux Tips and Tricks
White Paper 7 Things Every System Administrator Should Know About OpenSSH
Case Study Hard Hat Myth: Myths and Pitfalls of Data Mining
White Paper Troubleshooting Made Easy In Linux

» View all Linux - Open Source listings

advertisement

White Papers, Webcasts, and Resources

Featured Training Courses

advertisement

SmartPlanet

  • Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
  • More from IBM
  • Innovate your business' process model, play against the market, compete against others on our scoreboards and WIN! Try INNOV8 2.0: A BPM Simulator
  • Enabling Real-World Business Transformation through IBM Service Management Read the EMA Analyst Report
Click Here

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this library, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the ZDNet white paper newsletter and e-mail Must-Read News Alerts. You can unsubscribe from these at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).