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

Source: Internet
Author: User
Tags type null phpmyadmin
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.

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