Advanced Search

Results 1 to 3 of 3

Thread: How to create foreign key under xampp with MYISAM engine?

  1. #1
    Join Date
    Aug 2007
    Location
    Malaysia
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default How to create foreign key under xampp with MYISAM engine?

    Hi..guys! How can I create foreign key in table which using MYISAM storage engine in xampp?

  2. #2
    Join Date
    Sep 2005
    Location
    India
    Posts
    1,626
    Thanks
    6
    Thanked 107 Times in 107 Posts

    Default

    I don't think MYISAM types of table support foreign keys in MySQL you need to use InnoDB type of tables for that in which there is a FOREIGN KEY constraint available using which this can be achieved. Refer the following links for more details. The first link has the explanation with some examples of creating foreign keys and the second one is an article about this.

    http://dev.mysql.com/doc/refman/5.0/...nstraints.html
    http://www.raditha.com/blog/archives/000490.html

  3. #3
    Join Date
    Aug 2007
    Location
    Malaysia
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks..If I change all of my table from MYISAM to InnoDB in sql file and import it again,would it affect data integrity?

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
  •