SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot fredmintah's Avatar
    Join Date
    Jun 2004
    Location
    Ghana
    Posts
    102
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Does Stored procedures and Triggers Works in MySQL


    Hello Gurus,
    How do I implement Stored Procedures and Triggers in MySQL.
    If this is not posible then how do you go about with a database if you want certain update go on when something trigger.
    eg. Deleting all details of a person if he/she decides to remove him/her account from a database.
    Thank buddys.

  2. #2
    SitePoint Enthusiast hb-sam's Avatar
    Join Date
    Jun 2004
    Location
    Australia
    Posts
    81
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Stored procedures and triggers won't come out till MySQL version 5. Otherwise you probably have to fall back to Oracle or other RDBMS that supports it.

    I have to admit I miss PL/SQL when I'm working with MySQL databases.

  3. #3
    FreeBSD The Power to Serve silver trophy pippo's Avatar
    Join Date
    Jul 2001
    Location
    Italy
    Posts
    4,514
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to a more appropriate forum :-)
    Mr Andrea
    Former Hosting Team Advisor
    Former Advisor of '03


Bookmarks

Posting Permissions

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