Mysql Help

Discussion in 'Open Source' started by Desi-Tek.com, Nov 16, 2006.

Thread Status:
Not open for further replies.
  1. Desi-Tek.com

    Desi-Tek.com New Member

    Joined:
    Oct 15, 2006
    Messages:
    370
    Likes Received:
    4
    Trophy Points:
    0
    Location:
    Mumbai
    How to use foreign key and store procedure in mysql? pls post the information with example.

    Regards,
    Dheeraj
     
  2. GNUrag

    GNUrag FooBar Guy

    Joined:
    Jun 22, 2004
    Messages:
    1,246
    Likes Received:
    5
    Trophy Points:
    0
    Location:
    Interwebs
    First make sure that you are using MySQL 5.x series which now has support for Stored Procedures, Views and Triggers. For foreign keys make sure that your tables are using InnoDB engine.

    it wont be wise of us to create examples for you and post here. Please do your homework first, let us know where you are stuck, and then ask.
     
  3. OP
    OP
    Desi-Tek.com

    Desi-Tek.com New Member

    Joined:
    Oct 15, 2006
    Messages:
    370
    Likes Received:
    4
    Trophy Points:
    0
    Location:
    Mumbai
    actually i know how to create view, sp, trigger in ms sql, is it same in mysql? or does it has any syntax difference?
     
  4. GNUrag

    GNUrag FooBar Guy

    Joined:
    Jun 22, 2004
    Messages:
    1,246
    Likes Received:
    5
    Trophy Points:
    0
    Location:
    Interwebs
  5. bukaida

    bukaida New Member

    Joined:
    Jul 21, 2005
    Messages:
    326
    Likes Received:
    1
    Trophy Points:
    0
    Location:
    KOLKATA
Thread Status:
Not open for further replies.

Share This Page