View Single Post
Old 02-25-2014, 07:36 AM  
Barry-xlovecam
It's 42
 
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 18,083
You mean this?

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
Barry-xlovecam is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote