MySQL storage engine Part 1 – CREATE, ALTER & Error Engine #1217 & #1214.

1. Use CREATE clause to create ENGINE <type>;
2. Use ALTER clause to change ENGINE <type>;
3. SHOW ENGINES to show engine types that available in localhost server.
4. SHOW TABLE STATUS that to show table's engine types.
5. Typical error example # 1217 "a FOREIGN KEY constraint fails" when convert engine type
     from InnoDB to MyISAM.
  -- It would be impact the accuracy of data retrieved between parent table to child table
      when decide to drop any key constraint.
  -- Create a new table instead drop keys.
  -- Drop Table If Exists.

6. Typical error example # 1214 " doesn't support FULLTEXT" when convert engine type
     from MyISAM to InnoDB.
  -- MySQL storage Engine feature details
     http://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_acid