Thread: Dbase triggers

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    chennai, tamil nadu, INDIA
    Posts
    27
    Rep Power
    0
    how to use dtabase triggers in mysql?
  2. #2
  3. Wiking
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Sep 2000
    Location
    Sweden
    Posts
    3,608
    Rep Power
    26
    If you read the manual you'd know that mysql doesn't support triggers. You will have to do a workaround...

    /NoXcuz
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4476
    Do you speak english? Do you know what a manual is? Read it. Every question I've seen from you is something you should already know from reading the manual. Just looking at the table of comments will answer most of your questions...

    Let me help you.. http://www.mysql.com/documentation/mysql/bychapter

    ---JH
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    6
    Rep Power
    0
    -The second reply was impolite but nevermind

    - Anyway,

    - If you read the mysql user manuals or any mysql books published by the "good" people of O'Reilly press.

    - You would discover mysql has no support
    for

    -CREATE VIEW Some_View
    -triggers
    -Referential Integrity (this is managed via Front end)
    -The current version of mysql support transactions but previous versions of mysql doesn't support transactions.


    Looking forward to your feedback.

    dannyh

    n9905381@scholar.nepean.uws.edu.au

Similar Threads

  1. Any guidelines for using rules, triggers, etc?
    By kurious in forum PostgreSQL Help
    Replies: 7
    Last Post: June 9th, 2005, 01:49 PM
  2. HELP: Updating dbase fields from another dbase
    By asiaiceman in forum MySQL Help
    Replies: 0
    Last Post: February 8th, 2004, 04:53 AM
  3. adding a record and updating a dbase with a dataset
    By Dasmunchen in forum .Net Development
    Replies: 2
    Last Post: January 7th, 2004, 01:49 AM
  4. triggers??
    By johnstontrav in forum MySQL Help
    Replies: 3
    Last Post: October 5th, 2001, 02:07 AM
  5. performing query on dBase file
    By Kathyc in forum PHP Development
    Replies: 2
    Last Post: November 16th, 2000, 06:54 AM

IMN logo majestic logo threadwatch logo seochat tools logo