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
