I just changed a column type (timestamp --> date) in PHPmyadmin, but
when I checked the table structure in the mysql client immediately
afterwards, it showed up with the old column type!!
Has anyone else had something like this happen?
How can PHPmyadmin and the mysql client show different output?!!
PHPmyadmin:
Database credo - table Checklist
Field Type Attributes Null Default Extra Action
checklistID� int(11)� � No� 0� � Change
eventID� int(11)� � No� 0� � Change
label� varchar(50)� � No� � � Change
startDate� date� � Yes� � � Change
(CHANGED startDate COLUMN TO TYPE "date" from "timestamp(14)" BELOW)
statusID� int(11)� � No� 0� � Change
version� int(11)� � Yes� � � Change
MYSQL CLIENT: (See "StartDate" column type, "timestamp(14)"
mysql> show columns from checklist;
+-------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| checklistID | int(11) | | PRI | 0 | |
| eventID | int(11) | | | 0 | |
| label | varchar(50) | | | | |
| startDate | timestamp(14) | YES | | NULL | |
| statusID | int(11) | | | 0 | |
| version | int(11) | YES | | NULL | |
+-------------+---------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
