Hi!!
This just works fine for me..
C:\mysql\bin>mysql -uroot -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 137 to server version: 4.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(root@localhost) [(none)]> use test
Database changed
(root@localhost) [test]> CREATE TABLE `gl_weather_forecast` ( `timestamp` timestamp NOT NULL default 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
-> `cache` text,
-> `zip` varchar( 5 ) default NULL ,
-> UNIQUE KEY `zip` ( `zip` ) ) TYPE = MYISAM;
Query OK, 0 rows affected (0.09 sec)
(root@localhost) [test]> desc gl_weather_forecast;
+-----------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+-------+
| timestamp | timestamp(14) | YES | | NULL | |
| cache | text | YES | | NULL | |
| zip | varchar(5) | YES | MUL | NULL | |
+-----------+---------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
(root@localhost) [test]> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 4.0.18-nt |
+-----------+
1 row in set (0.00 sec)
(root@localhost) [test]>
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221