Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    77

    Unanswered: triggers support of mySQL

    Hi to all,

    Does mySQL databases supoort triggers? I just thought that the procedures or actions that are executed whenever something happens to a database is called a trigger.

    Is it possible in mySQL to execute a custom function or procedure when a new records is inserted? We have here a timekeeping program in our office which has a mySQL back-end and I want the newly inserted records to be computed by mySQL automatically. The processing must be done on mySQL.

    Is that all possible to do in mysQL. I believe that SQL Servers supports triggers and stored procedures, but I want to try out mySQL first.

    Thanks and god bless.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    yes mysql supports triggers.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by guelphdad
    yes mysql supports triggers.
    ...true MySQL does but only with version 5 or later
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Mar 2004
    Posts
    480
    indeed, but I figured that info could be found in the manual.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •