I have a table in my database. I suddenly cannot open it today .. In phpmyadmin, when you click the table prompt "Unknowncolumnoperatorinwhereclauseorder", it means that the table cannot be browsed because there is a table in my database and it cannot be opened 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 ..