mysql>
mysql> CREATE TABLE mytbl
-> (
-> i INT,
-> c CHAR(1)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> SHOW CREATE TABLE mytbl\G
*************************** 1. row ***************************
Table: mytbl
Create Table: CREATE TABLE `mytbl` (
`i` int(11) DEFAULT NULL,
`c` char(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
mysql>
mysql> drop table mytbl;
Query OK, 0 rows affected (0.00 sec)
mysql>