Coding Cheatsheets - Learn to Code

Change table engine to MyISAM ALTER TABLE `tableName` ENGINE = MYISAM Change table engine to innodb ALTER TABLE `tableName` ENGINE = innodb How to create table to MYISAM mysql> CREATE TABLE table2 (col1 INT, col2 CHAR(30)) ENGINE = MYISAM; Features of MYISAM and INNODB Feature InnoDB MyISAM Storage limits 64TB 256TB Transactions Yes No Locking granularity Row Table MVCC Yes No B-tree indexes Yes Yes Clustered indexes Yes No Data caches Yes No MyISAM MyISAM doesn’t support foreign key constraints or transactions , which are essential for data integrity. Hence we call MySQL with MYISAM is DBMS MYISAM not supports transaction. You cannot commit and rollback with MYISAM. MYISAM supports Table-level Locking : In addition, the whole table is locked whenever a record is inserted or updated; this causes a detrimental...