SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Get my greedy down dotJoon's Avatar
    Join Date
    Apr 2003
    Location
    daejeon, South Korea
    Posts
    2,223
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    MyISAM or InnoDB

    How can I find that MYSQL in my computer is MyISAM or InnoDB?

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,072
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    MyISAM and InnoDB are both types of storage engine. An easy way to find out which one a table is using is to view the list of tables on a database in something like phpmyadmin
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Evangelist hessodreamy's Avatar
    Join Date
    Apr 2005
    Location
    uk
    Posts
    525
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Your mySql server will support both of these table types. When you create a table you can simply specify the table type (storage engine and table type are the same thing) you want
    eg
    Code:
    CREATE TABLE test_table(testID INT PRIMARY KEY, testText text) ENGINE=MyISAM
    If you don't specify a storage engine type when you create the table, it will use the default type set on the mySql server. If you want to know what this is on your server, run the command 'SHOW VARIABLES'. Which will show the server settings. I think the variable 'table_type' is the default engine.

    Another way to the what storage engine a table is using is the 'SHOW CREATE TABLE my_table_name' command. This will give you the code to recreate the structure of the chosen table, including whatever storage engine it is using.


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
  •