A strange thing in MySQL

I have a table in my database and I can't open it today.

In phpMyAdmin, click Table hint Unknown column ' operator ' in ' WHERE clause order ' means that there is no operator this field

Although this table is not able to browse the information, but can see the structure I opened the structure and looked at it. There really is no operator field, and I suddenly recall that this table

Seems to have this field later do not know why the deletion, but now this situation also let me not touch the mind ah, no no ah why do you want to error, my watch

There is no Mao Zedong this field ah why I must have operator this field ...

Observe phpMyAdmin's address bar found is get way in the argument, so think is not browser cache, put this operator condition added, so clean up the browser cache

Come back a try, or invalid, I also don't care what data in it, simply emptied the table to see,

DELETE from ' Dj_driver_charge ' WHERE 1; This line of code is executed in the phpMyAdmin SQL box, and the error

The statement in the red error above turns my statement into this: DELETE from ' dj_driver_charge ' ORDER by operator limit 1,25 I can't remember now,

Anyway, it probably means that according to operator to delete the data in the table, I am strange, this operator out of the ....

Then copy the red Error statement above into the SQL box below to replace the operator with an existing field

OK delete success, now click Browse finally no error

Summary: The personal guess should be the database itself has a cache, if the use of the database is more than a lot of people should have encountered, before encountering once I thought the table was damaged ... Directly deleted.

Re-built, this is finally clear.

A strange thing in MySQL