A strange thing in mysql

Source: Internet
Author: User

A strange thing in mysql

I have a table in my database. I suddenly cannot open it today ..

In phpmyadmin, click the table prompt "Unknown column 'operator' in 'where clause order'", which means there is no operator field.

Although this table cannot browse the information, you can view the structure. I clicked the Open Structure and saw that there was indeed no operator field. I suddenly recalled the previous table.

It seems that I did not know why I deleted this field, but now this situation makes me confused. If not, I will not. Why are you reporting an error? My table

There is no such field as Mao Zedong. Why should I have the operator field...

Observe the address bar of phpmyadmin and find that the parameter is passed through the get method, so I thought it was a browser cache, and added the operator condition, so I cleared the browser cache.

I tried it again, but it still didn't work. No matter what sub-data is in it, I simply cleared the table and looked at it,

Delete from 'Dj _ driver_charge 'WHERE 1; this line of code is executed in the phpmyadmin SQL box, and an error is returned.

The statement prompted in the red error above turns my statement into this: delete from 'Dj _ driver_charge 'order by operator limit I cannot remember how to write it now,

Anyway, it probably means that the operator is used to delete the data in the table. It's strange to me that this operator came out ....

Copy the preceding red error statement to the following SQL box and replace operator with an existing field.

OK. Now Click Browse. No error is reported.

Summary: My personal guess is that the database itself has a cache. If a large number of databases are used, many people may have encountered this problem. I thought the table was damaged once before... Deleted directly

Re-build, now clearly understood ..

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.