I am trying to create a simple table with Innodb engine.
CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;
But, when i do
SHOW TABLE STATUS LIKE ‘customers’;
In the Engine type column, it says Myisam. Can some one please help!