mysql>
mysql> CREATE TABLE mytbl
-> (
-> i INT,
-> c CHAR(1)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> SHOW COLUMNS FROM mytbl;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| i | int(11) | YES | | NULL | |
| c | char(1) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.01 sec)
mysql>
mysql> drop table mytbl;
Query OK, 0 rows affected (0.00 sec)