SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru
    Join Date
    Jan 2005
    Location
    USA
    Posts
    633
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    InnoDb and MyIsam

    HI all

    Could someone please tell me the difference between Innodb and myisam.
    I was told that referenial integrity cannot be achieved with a MyIsam table
    in Mysql..is that true, if so then I am not able to use the FOREIGN KEY.Am I right in saying that.

    Also can I use Innodb or do I need additional modules to me installed.

    Is innodb suitable for a database of less that 5000 records.

    Also is myisam default or do I have to specify it when I create the table.

    Please assist

    Didi

  2. #2
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    You were told correctly. MyISAM tables do not enforce Primary and Foreign Key constraints. You can use the code for them but MySQL will just drop them. MyISAM is the default database type. To use InnoDB you need the "Type=InnoDB;" at the end of your create table statements, you also need to make sure that your host has InnoDB enabled.

    InnoDB does enforce referential integrity and would be great for a database of 5000 records. The only thing you can't do with InnoDB is FULLTEXT searches (http://dev.mysql.com/doc/mysql/en/fulltext-search.html).

  3. #3
    SitePoint Guru
    Join Date
    Jan 2005
    Location
    USA
    Posts
    633
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    HI

    Thanks for the reply,

    I have nt heard of fulltext, can you give me an example

    Didi

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Didi, there's a Search box in the top right corner of this page -- http://www.mysql.com

    i think you will be pleasantly surprised at the different examples you can find by searching for "fulltext"

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by dd1313
    HI

    Thanks for the reply,

    I have nt heard of fulltext, can you give me an example

    Didi
    I actually gave you a link to FULLTEXT in my first post


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
  •