mysql> use test;
Database changed
mysql> show tables;
+ ----------------+
 
| Tables_in_test |
+ ----------------+
 
| _commentbase   |
| _itemlog       |
| date_test      |
| tbl_cnt        |
| tbl_usr        |
+ ----------------+
 
 5  rows in set ( 0 . 00  sec)

mysql> show columns from date_test;
+ -----------+---------------------+------+-----+------------+----------------+
 
| Field     | Type                | Null | Key | Default    | Extra          |
+ -----------+---------------------+------+-----+------------+----------------+
 
| id        | bigint( 20 ) unsigned |      | PRI | NULL       | auto_increment |
| post_date | date                | YES  |     |  0000 - 00 - 00  |                |
+ -----------+---------------------+------+-----+------------+----------------+
 
 2  rows in set ( 0 . 03  sec)

mysql>