MYSQL Server version: 5.5
-- creazione tabella di esempio t table
mysql> create table t (i integer);
Query OK, 0 rows affected (0.00 sec)

-- inserimento alcune righe
mysql> insert into t values (1),(2),(3),(4),(5),(6);
Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0

-- descrizione della struttura della tabella
mysql> desc t;

+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| i     | int(11) | YES  | MUL | NULL    |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)

-- ricavare stato della tabella (MyISAM o InnoDBInnoDB, numero di righe, statistiche, data di creazione)
mysql> show table  status  like 't';  

+------+--------+------------+------+-------------+------------------+---------------+---------------------+------------------+
| Name | Engine | Row_format | Rows | Data_length | Max_data_length  |Auto_increment | Create_time         |Collation         |
+------+--------+------------+------+-------------+------------------+---------------+---------------------+------------------+
| t    | MyISAM | Fixed      |    6 |          42 | 1970324836974591 |          NULL | 2012-04-24 09:39:45 |latin1_swedish_ci |
+------+--------+------------+------+-------------+------------------+---------------+---------------------+------------------+
(...)
1 row in set (0.00 sec)

-- creazione indice di esempio
mysql> create index idx1 on t(i);

Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0
-- visualizzazione indici della tabella

mysql> show indexes from t;

+-------+------------+----------+--------------+-------------+------------+----------+--------+------+------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |Cardinality | Sub_part | Packed | Null | Index_type |
+-------+------------+----------+--------------+-------------+------------+----------+--------+------+------------+
| t     |          1 | idx1     |            1 | i           |       NULL |     NULL | NULL   | YES  | BTREE      |
+-------+------------+----------+--------------+-------------+------------+----------+--------+------+------------+
(...)
1 row in set (0.00 sec)


-- ricavare comando ddl per generare la tabella con i suoi indici
mysql> show create table t;

+-------+----------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                             |
+-------+----------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `i` int(11) DEFAULT NULL,
  KEY `idx1` (`i`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)