ORDER BY Btcount Desc or ORDER by Btcount invalid, what sort of writing is there?

SELECT * FROM table where yz= ' 1 ' ORDER BY btcount Desc This writes output is incorrect,

Btcount This field is very short, generally =0 or = 1, maximum no more than =8

When the amount of data is large, you cannot press the Btcount value of greater than the arrangement, do not know why?

By time and correctly sorted: SELECT * from table where yz= ' 1 ' ORDER by time Desc

Is the Btcount not sorted correctly because the Btcount field length is too short?

But in the phpMyAdmin click Ascending, descending and effective, want to know phpMyAdmin is not in order by to the ascending, descending?


User Btcount Time ID
AAA 0 1359119507 1
BBB 2 1359119506 2
CCC 0 1359119502 4
DDD 1 1359119501 6
Eee 0 1359119467 7
FFF 3 1359119467 9
GGG 2 1359116785 13
HHH 0 1359119687 15

Please master teach me how to write correctly output?

Reply to discussion (solution)

SELECT * FROM table where yz= ' 1 ' ORDER by btcount Desc

Where is the YZ field?

SELECT * FROM table where yz= ' 1 ' ORDER by btcount Desc

Where is the YZ field?

Because YZ is equal, so I'm not going to hit it in the table below, it's irrelevant.

Let's see how phpMyAdmin wrote it. Normal you click the button, the above will have the corresponding SQL code.

Let's see how phpMyAdmin wrote it. Normal you click the button, the above will have the corresponding SQL code.

See, that too complex, can not understand, so only to consult master.

Let's see how phpMyAdmin wrote it. Normal you click the button, the above will have the corresponding SQL code.

See, that too complex, can not understand, so only to consult master.
Then you post the SQL code. You don't post it out who knows what the reason is.

Then you post the SQL code. You don't post it out who knows what the reason is.

It's not written:
SELECT * FROM table where yz= ' 1 ' ORDER by btcount Desc

Then you post the SQL code. You don't post it out who knows what the reason is.

It's not written:
SELECT * FROM table where yz= ' 1 ' ORDER by btcount Desc



It's no problem to look at the code.
Or try it.

SELECT * from ' table ' where yz= ' 1 ' ORDER by btcount Desc

It's no problem to look at the code.
Or try it.

SELECT * from ' table ' where yz= ' 1 ' ORDER by btcount Desc

Useless, if simple I will not ask, thank you, please do not reply, wait for master!

Look at the code is no problem, paste the table and insert the statement to see.

Explain a little bit of your statement.
Another btcount is int, var or what format?

Explain a little bit of your statement.
Another btcount is int, var or what format?

Field type Null default
Btcount Int (6) No 0

I don't know what you want to export.
For your main paste so-called query statements and data, you can get the results

User     Btcount         time       idfff        3        1359119467       9bbb        2        1359119506       2ggg        2        1359116785       13ddd        1        1359119501       6aaa        0        1359119507       1ccc        0        1359119502       4eee        0        1359119467       7hhh        0        1359119687       15

I don't know what you want to export.
For your main paste so-called query statements and data, you can get the results

User     Btcount         time       idfff        3        1359119467       9bbb        2        1359119506       2ggg        2        1359116785       13ddd        1        1359119501       6aaa        0        1359119507       1ccc        0        1359119502       4eee        0        1359119467       7hhh        0        1359119687       15

Thank you, just want this output effect, code is?

SELECT * FROM table ORDER BY btcount DESC

You'd better put
Explain select * FROM table where yz= ' 1 ' ORDER by btcount Desc
The results are posted.

