Here's a clearer indication of the problem I mentioned earlier:
In the mysql client terminal output below, note how the column type of
startDate does not show up as changed from timestamp to date (even
though I had changed it earlier in phpmyadmin) until I run "Repair
Table" on the table in PHPMYADMIN. Is the Repair Table command
refreshing the table cache or something else that PHPMYADMIN is failing
to do?
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.00 sec)
mysql> exit
Bye
[localhost:Documents/somehost/credo] root# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 950 to server version: 3.23.38
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> use credo;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
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.03 sec)
mysql> repair table checklist;
+-----------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------+--------+----------+----------+
| credo.checklist | repair | status | OK |
+-----------------+--------+----------+----------+
1 row in set (0.04 sec)
mysql> show columns from checklist;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| checklistID | int(11) | | PRI | 0 | |
| eventID | int(11) | | | 0 | |
| label | varchar(50) | | | | |
| startDate | date | YES | | NULL | |
| statusID | int(11) | | | 0 | |
| version | int(11) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
mysql>
On Tuesday, July 10, 2001, at 08:08 AM, Werner Stuerenburg wrote:
>> 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?
>
> No. I just tested, everything ok.
>
>> How can PHPmyadmin and the mysql client show different output?!!
>
> phpMyAdmin shows you the query. Check it for consistency.
>
>
> --
> Herzlich
> Werner Stuerenburg
>
> _________________________________________________
> ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
> Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
> http://pferdezeitung.de
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-unsubscribe-
> [EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
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
