Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 64 to server version: 4.0.16-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> USE test; Database changed mysql> DROP TABLE IF EXISTS `CaseIsImportant`; Query OK, 0 rows affected (0.08 sec) mysql> CREATE TABLE `CaseIsImportant` (`idCorrectCase` CHAR(1)) TYPE=InnoDB; Query OK, 0 rows affected (0.14 sec) mysql> DESCRIBE `CaseIsImportant`; +---------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------+------+-----+---------+-------+ | idCorrectCase | char(1) | YES | | NULL | | +---------------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> SHOW TABLES; +-----------------+ | Tables_in_test | +-----------------+ | caseisimportant | +-----------------+ 1 row in set (0.00 sec) mysql> SHOW CREATE TABLE `CaseIsImportant`; +-----------------+---------------------------------------------------------------------------------------+ | Table | Create Table | +-----------------+---------------------------------------------------------------------------------------+ | CaseIsImportant | CREATE TABLE `caseisimportant` ( `idCorrectCase` char(1) default NULL ) TYPE=InnoDB | +-----------------+---------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> EXIT;