当前位置: 动力学知识库 > 问答 > 编程问答 >

database - Mysql bug, ghost column

问题描述:

I delete a column in mysql called "clanName" and i see this:

I can't edit it, and that column doesn't exists.

I restart mysql and Xampp and continue...

Any ideas?

网友答案:

There is a tab called 'Operations.' Click on that tab and duplicate this table. There is an excellent chance that your duplicated version will no longer contain the empty column.

If this works, you can then rename the original version by appending the word 'BACKUP' to the name. Then rename your newly duplicated copy to the original table's name and test. If everything works with your project, you may wish to delete the old (and broken!) backup copy.

Good luck, please let me know if this works for you. If it does not please export a copy of the database table and post it here on StackOverflow. I will be happy to examine it further.

分享给朋友:
您可能感兴趣的文章:
随机阅读: