[DiscordArchive] anyone know why i can't sort by ids in heidisql?
[DiscordArchive] anyone know why i can't sort by ids in heidisql?
Original source
anyone know why i can't sort by ids in heidisql?
rektbyfaith
09-06-2024, 09:24 PM #1Archived author: protopulse • Posted: 2024-09-06T21:24:38.838000+00:00
Original source
anyone know why i can't sort by ids in heidisql?
Original source
![[Image: image.png?ex=690c6967&is=690b17e7&hm=a89...abf7d2740&]](https://cdn.discordapp.com/attachments/1255602330431127753/1281726852695855235/image.png?ex=690c6967&is=690b17e7&hm=a89a00b056cfff89478990f40dfdd0369da12620321e661d29c86e2abf7d2740&)
rektbyfaith
09-06-2024, 09:24 PM #2Archived author: protopulse • Posted: 2024-09-06T21:24:55.068000+00:00
Original source
Original source
usually i just click the header of the id column and it does it, but now it does nothing
rektbyfaith
09-06-2024, 09:25 PM #3Archived author: protopulse • Posted: 2024-09-06T21:25:09.984000+00:00
Original source
usually i just click the header of the id column and it does it, but now it does nothing
Original source
Open up the Query tab and enter your table name into the below:
SELECT * FROM tablename
ORDER BY ID Desc
rektbyfaith
09-06-2024, 09:48 PM #4Archived author: Sedge • Posted: 2024-09-06T21:48:05.450000+00:00
Original source
Open up the Query tab and enter your table name into the below:
SELECT * FROM tablename
ORDER BY ID Desc
Original source
okay give me a sec, ill try that
rektbyfaith
09-06-2024, 09:48 PM #5Archived author: protopulse • Posted: 2024-09-06T21:48:47.611000+00:00
Original source
okay give me a sec, ill try that
Original source
alternatively, see how there's a filter on username in your screenshot? Click on that header another time or two until it disappears. It's messing up your ordering. Likely more as well (1, 2, 3...)
![[Image: image.png?ex=690c6f3f&is=690b1dbf&hm=7c7...617586887&]](https://cdn.discordapp.com/attachments/1255602330431127753/1281733128418754592/image.png?ex=690c6f3f&is=690b1dbf&hm=7c7b789a420e1f1103dffc72e936a71b7701cc21e6ff8a8feb93d5d617586887&)
rektbyfaith
09-06-2024, 09:49 PM #6Archived author: Sedge • Posted: 2024-09-06T21:49:51.411000+00:00
Original source
alternatively, see how there's a filter on username in your screenshot? Click on that header another time or two until it disappears. It's messing up your ordering. Likely more as well (1, 2, 3...)
Original source
ooh
rektbyfaith
09-06-2024, 09:50 PM #7Archived author: protopulse • Posted: 2024-09-06T21:50:15.888000+00:00
Original source
ooh
Original source
yea
rektbyfaith
09-06-2024, 09:51 PM #8Archived author: protopulse • Posted: 2024-09-06T21:51:38.711000+00:00
Original source
yea
Original source
i didnt realize i had other filters on as well
rektbyfaith
09-06-2024, 09:51 PM #9Archived author: protopulse • Posted: 2024-09-06T21:51:45.867000+00:00
Original source
i didnt realize i had other filters on as well
Original source
![[Image: image.png?ex=690c6fb3&is=690b1e33&hm=f5c...14ecfb8e2&]](https://cdn.discordapp.com/attachments/1255602330431127753/1281733613989396601/image.png?ex=690c6fb3&is=690b1e33&hm=f5c8f5fd254a6801a3548034d0df362a6dcfd0bc33380595eb0f74514ecfb8e2&)
rektbyfaith
09-06-2024, 09:51 PM #10Archived author: protopulse • Posted: 2024-09-06T21:51:47.115000+00:00
Original source
1 Guest(s)
1 Guest(s)