[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
now it works again
rektbyfaith
09-06-2024, 09:51 PM #11Archived author: protopulse • Posted: 2024-09-06T21:51:50.892000+00:00
Original source
now it works again
Original source
let me try your command just for learning purposes
rektbyfaith
09-06-2024, 09:51 PM #12Archived author: protopulse • Posted: 2024-09-06T21:51:58.534000+00:00
Original source
let me try your command just for learning purposes
Original source
```SELECT * FROM `acore_auth`.`account`
ORDER BY ID ASC
```
rektbyfaith
09-06-2024, 09:53 PM #13Archived author: protopulse • Posted: 2024-09-06T21:53:35.789000+00:00
Original source
```SELECT * FROM `acore_auth`.`account`
ORDER BY ID ASC
```
Original source
yep!
rektbyfaith
09-06-2024, 09:53 PM #14Archived author: protopulse • Posted: 2024-09-06T21:53:36.844000+00:00
Original source
yep!
Original source
works great thank you
rektbyfaith
09-06-2024, 09:53 PM #15Archived author: protopulse • Posted: 2024-09-06T21:53:40.933000+00:00
Original source
works great thank you
Original source
It's manual searching.
Select all records from <tablename>
order them by the ID column in descending order.
Between these, you can filter your data. Example, where you want only to see IDs greater than 100
Select * from account
Where ID > 100
Order by ID Desc
rektbyfaith
09-06-2024, 09:54 PM #16Archived author: Sedge • Posted: 2024-09-06T21:54:08.975000+00:00
Original source
It's manual searching.
Select all records from <tablename>
order them by the ID column in descending order.
Between these, you can filter your data. Example, where you want only to see IDs greater than 100
Select * from account
Where ID > 100
Order by ID Desc
Original source
mysql uses ` instead of quotations for string names huh
rektbyfaith
09-06-2024, 09:54 PM #17Archived author: protopulse • Posted: 2024-09-06T21:54:40.518000+00:00
Original source
mysql uses ` instead of quotations for string names huh
Original source
If you list in just what I posted above, it will also work. The apostrophes enclose a string in the event there is a conflict or spacing.
rektbyfaith
09-06-2024, 09:56 PM #18Archived author: Sedge • Posted: 2024-09-06T21:56:23.514000+00:00
Original source
If you list in just what I posted above, it will also work. The apostrophes enclose a string in the event there is a conflict or spacing.
Original source
Once you get super serious, you can query across multiple tables and join on shared values (such as ID) to correlate data into a single table
rektbyfaith
09-06-2024, 09:57 PM #19Archived author: Sedge • Posted: 2024-09-06T21:57:51.223000+00:00
Original source
Once you get super serious, you can query across multiple tables and join on shared values (such as ID) to correlate data into a single table
Original source
Sorry, ADHD kicking in.
```
SELECT account.id, account.username, characters.name, characters.level, characters.xp, account.last_login
FROM acore_auth.account
LEFT JOIN acore_characters.characters
ON characters.account = ACCOUNT.id
WHERE last_login IS NOT NULL
ORDER BY last_login desc```
rektbyfaith
09-06-2024, 10:11 PM #20Archived author: Sedge • Posted: 2024-09-06T22:11:16.192000+00:00
Original source
Sorry, ADHD kicking in.
```
SELECT account.id, account.username, characters.name, characters.level, characters.xp, account.last_login
FROM acore_auth.account
LEFT JOIN acore_characters.characters
ON characters.account = ACCOUNT.id
WHERE last_login IS NOT NULL
ORDER BY last_login desc```
1 Guest(s)
1 Guest(s)