Link to home
Start Free TrialLog in
Avatar of Sandy Sailer
Sandy SailerFlag for United States of America

asked on

cannot rename table in PHP MyAdmin

I have tried numerous times to create a table in MySQL (via PHP MyAdmin) and I keep getting the same error:  #1146 - Table 'cibcontacts.customerstatus' doesn't exist.  So, I created a new table called example, and tried to rename it to customerstatus, but it says #1050 - Table 'customerstatus' already exists.  Gggggrrrrrr!  Why is it doing this?  This has happened before and it has been such a pain to work around.  Help!!!???
ASKER CERTIFIED SOLUTION
Avatar of Lukasz Chmielewski
Lukasz Chmielewski
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandy Sailer

ASKER

PERFECT!!!  Thank you!  Crazy MySQL!!!
Suggestion worked perfectly.