DanDaBeginner Posted March 2, 2007 Share Posted March 2, 2007 ??? I have no idea on what is InnoDB and MyISAM, can somebody elaborate it to me? they are related to tables right not in the database it self? I been using PHPMyadmin so Im not aware of this. is there another more of their kind? what are this? what are the advantages and disadvantages of using this? If there are articles tuckled this that dont give very technical explanation that can cause the reader to not understand, please give me the link.. thanx DanDaBeginner Quote Link to comment Share on other sites More sharing options...
phpfan Posted March 2, 2007 Share Posted March 2, 2007 There main difference is that using InnoDB tables you can create foreign keys on phpMyAdmin something that you can't do using MYISAM tables. I think you should check http://phpmyadmin.sourceforge.net/documentation/ for a start... Quote Link to comment Share on other sites More sharing options...
DanDaBeginner Posted March 2, 2007 Author Share Posted March 2, 2007 than for the help phpfan! I will read this url... but im not referring to PHPMyAdmin im referring to MYSQL... Quote Link to comment Share on other sites More sharing options...
fenway Posted March 2, 2007 Share Posted March 2, 2007 InnoDB allows for transaction-safe tables, so that you can group sql statements to be run "at the same time", and not otherwise. It also allows you to enforce relations between records in different tables. But all of this comes at a very expensive cost in terms of resources, code management, db design, etc. Quote Link to comment Share on other sites More sharing options...
DanDaBeginner Posted March 3, 2007 Author Share Posted March 3, 2007 hhmm! so you mean the code: transaction query1 query2 commit; is available only in InnoDB? thanx again.. Quote Link to comment Share on other sites More sharing options...
artacus Posted March 3, 2007 Share Posted March 3, 2007 See for yourself http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html Quote Link to comment Share on other sites More sharing options...
DanDaBeginner Posted March 3, 2007 Author Share Posted March 3, 2007 thanx for the help..... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.