[DiscordArchive] Hello, is there a way to find and delete duplic...
[DiscordArchive] Hello, is there a way to find and delete duplic...
Original source
If I want to have all items, the number also starts below 56806. I have already checked this. I am only interested in equipment and weapons. So far everything is working. I have done a lot of tests and am just in the process of sorting out duplicate display IDs. Thanks for the tip.
rektbyfaith
09-13-2025, 07:37 PM #11Archived author: Lordthunder • Posted: 2025-09-13T19:37:05.928000+00:00
Original source
If I want to have all items, the number also starts below 56806. I have already checked this. I am only interested in equipment and weapons. So far everything is working. I have done a lot of tests and am just in the process of sorting out duplicate display IDs. Thanks for the tip.
Original source
Question: Does it delete all duplicate entries, or does it leave me one for each duplicate? For example, if there are five duplicate entries in display ID 3465, does it delete all five or just four? Do I have to choose what I delete myself? I use Heidisql.
rektbyfaith
09-14-2025, 07:17 AM #12Archived author: Lordthunder • Posted: 2025-09-14T07:17:11.432000+00:00
Original source
Question: Does it delete all duplicate entries, or does it leave me one for each duplicate? For example, if there are five duplicate entries in display ID 3465, does it delete all five or just four? Do I have to choose what I delete myself? I use Heidisql.
Original source
It does not delete anything. It selects for you the duplicates.. you can delete them afterwards.
rektbyfaith
09-14-2025, 09:31 AM #13Archived author: Conastro • Posted: 2025-09-14T09:31:19.703000+00:00
Original source
It does not delete anything. It selects for you the duplicates.. you can delete them afterwards.
Original source
Thanks Is there a way for it to delete it too or do I have to do the rest myself?
rektbyfaith
09-14-2025, 02:43 PM #14Archived author: Lordthunder • Posted: 2025-09-14T14:43:55.773000+00:00
Original source
Thanks Is there a way for it to delete it too or do I have to do the rest myself?
Original source
Well there does exist delete function in sql.. but as far as my knowledge goes, I don't know how to write, what you require, in SQL
rektbyfaith
09-14-2025, 09:25 PM #15Archived author: Conastro • Posted: 2025-09-14T21:25:42.338000+00:00
Original source
Well there does exist delete function in sql.. but as far as my knowledge goes, I don't know how to write, what you require, in SQL
Original source
Thank you for the information. What I get from you is enough for me. Thank you for the help.
rektbyfaith
09-15-2025, 04:42 AM #16Archived author: Lordthunder • Posted: 2025-09-15T04:42:04.781000+00:00
Original source
Thank you for the information. What I get from you is enough for me. Thank you for the help.
1 Guest(s)
1 Guest(s)