Console + phpMyAdmin not showing updated column names?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Console + phpMyAdmin not showing updated column names?

Post by JAB Creations »

In phpMyAdmin I have not been seeing the updated column names when I revised the naming scheme for columns.

Then to be sure before I started this thread I loaded up DOS and then entered in to MySQL console. I connect, use, describe, and the column names appear as the same old columns names do in phpMyAdmin!

I changed these column names at least two or three weeks ago so I've rebooted my system numerous times since then. I'm not sure what to do and disabling and clearing the cache while obvious clearly hasn't helped me out.

The odd thing is when I execute MySQL queries though PHP I have to select the new column names...and now that I can't view them I'm only getting even more confused...can any one imagine that? :|

Has any one encountered this before? Suggestions please?

The following did not work...
RESET QUERY CACHE
FLUSH TABLES
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: Console + phpMyAdmin not showing updated column names?

Post by JAB Creations »

I manually renamed the columns and they appear to display fine now. I'm still not sure how this happened though I'll know what I have to do if I see any broken MySQL queries.
Post Reply