myisam is the default storage engine . it is optimised for speed .innodb is optimised for data integrity . I am not sure which one to use when (feel free to comment on this ) . To change from myisam to innodb -
ALTER TABLE tbwithMyISAM CHANGE TYPE=InnoDB
Post your trick
mysql storage engines
One Response to “mysql storage engines”
Leave a Reply
Post A Trick !
How does "Kodetricks" work?
We at kodeplay like to share knowledge. With Kodetricks, even you can join us. All you need to do is post a programming related trick if you have one or rate a trick if you like someone else's.
one more difference is that the default storage engine i.e. myisam doesn’t support foreign key for that u have to change it to innodb