Code:
barry:~$ mysql -u****** -p*******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1016
Server version: 5.***************************
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| models |
| mysql |
| test |
+--------------------+
11 rows in set (0.00 sec)
mysql> use models;
mysql> show tables;
+------------------+
| Tables_in_models |
+------------------+
| modelData |
+------------------+
1 row in set (0.00 sec)
mysql> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'models';
+-------------+--------+
| TABLE_NAME | ENGINE |
+-------------+--------+
| modelData | INNODB |
+-------------+--------+
1 row in set (0.06 sec)
Quote:
http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
ALTER TABLE changes the structure of a table. For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. You can also change characteristics such as the storage engine used for the table or the table comment.
|
Code:
mysql> ALTER TABLE table_name ENGINE = INNODB;
Just make it work :P
Nice references website 
http://mysqlresources.com/documentation/db-table-schema