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 Link to comment https://forums.phpfreaks.com/topic/40825-solved-question-with-innodb-and-myisam/ 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... Link to comment https://forums.phpfreaks.com/topic/40825-solved-question-with-innodb-and-myisam/#findComment-197706 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... Link to comment https://forums.phpfreaks.com/topic/40825-solved-question-with-innodb-and-myisam/#findComment-197781 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. Link to comment https://forums.phpfreaks.com/topic/40825-solved-question-with-innodb-and-myisam/#findComment-198070 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.. Link to comment https://forums.phpfreaks.com/topic/40825-solved-question-with-innodb-and-myisam/#findComment-198415 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 Link to comment https://forums.phpfreaks.com/topic/40825-solved-question-with-innodb-and-myisam/#findComment-198417 Share on other sites More sharing options...
DanDaBeginner Posted March 3, 2007 Author Share Posted March 3, 2007 thanx for the help..... Link to comment https://forums.phpfreaks.com/topic/40825-solved-question-with-innodb-and-myisam/#findComment-198419 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.