SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2004
    Location
    Glen Ellyn
    Posts
    55
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MyISAM or InnoDB

    How can I tell if my tables are MyISAM or InnoDB?

    Thanks

  2. #2
    Umm. PHP Guru....Naaaah jaswinder_rana's Avatar
    Join Date
    Jul 2004
    Location
    canada
    Posts
    3,193
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am not very good in that field but while creating a table in mysql if you don't specify any type then by default it is MyISAM.
    that's all i know about it.

  3. #3
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you are creating the table then yes you would know if it is INNODB or not. If the table is already created then use this to find out it if is INNODB or not:

    Code:
     SHOW CREATE TABLE tablename


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
  •