Console + phpMyAdmin not showing updated column names?
Posted: Sat Dec 06, 2008 2:14 am
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
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