Mysql is a strange thing.

Mysql is a strange thing.

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 ..

A strange problem with MYSQL

Although not quite familiar with this syntax
Do you think this line is true?
IF (SELECT id FROM zo_user WHERE user = usr)> 0 THEN

Change to -->
IF (SELECT id FROM zo_user WHERE user = usr)> 0) THEN

Add brackets ~
If an error is reported, Your syntax is incorrect...
If you think the syntax is correct, it is the computer's fault ~~~ Haha

Then, let's see if there is a semicolon missing in your 2nd rows?
Haha, I really don't understand this, only oracle...

A strange question about mysql Query

... There is no conflict. You are wrong about the describe statement.

Part 1
According to your statement, I guess you want to create a database, but this database instance already exists, so it answers you database exists
Part 2

Describe describes "tables... According to what you mean, you may want to see what the bookdb database is like, but your statements cannot express this meaning. The Compiler follows the original describe usage, understand your bookdb as a table, because you have never created a table called bookdb. Of course, it prompts that the bookdb table does not exist.