Forums WoW Modding Support Archives Azerothcore Discord Archives [DiscordArchive] Any SQL Gurus out here? I need some help with a query. I want to select two rows from one table and

[DiscordArchive] Any SQL Gurus out here? I need some help with a query. I want to select two rows from one table and

[DiscordArchive] Any SQL Gurus out here? I need some help with a query. I want to select two rows from one table and

rektbyfaith
Administrator
0
03-07-2021, 10:14 AM
#1
Archived author: Hacki • Posted: 2021-03-07T10:14:41.393000+00:00
Original source

Any SQL Gurus out here? I need some help with a query. I want to select two rows from one table and place the values into another table (also two rows, not together) with something like WHERE table1.entry = table2.entry... Anyone know how such a Query would look like?
rektbyfaith
03-07-2021, 10:14 AM #1

Archived author: Hacki • Posted: 2021-03-07T10:14:41.393000+00:00
Original source

Any SQL Gurus out here? I need some help with a query. I want to select two rows from one table and place the values into another table (also two rows, not together) with something like WHERE table1.entry = table2.entry... Anyone know how such a Query would look like?

rektbyfaith
Administrator
0
03-07-2021, 11:11 AM
#2
Archived author: Honey • Posted: 2021-03-07T11:11:08.284000+00:00
Original source

you answer is most likely on stackoverflow already
rektbyfaith
03-07-2021, 11:11 AM #2

Archived author: Honey • Posted: 2021-03-07T11:11:08.284000+00:00
Original source

you answer is most likely on stackoverflow already

rektbyfaith
Administrator
0
03-07-2021, 11:11 AM
#3
Archived author: Hacki • Posted: 2021-03-07T11:11:21.707000+00:00
Original source

Hehehe yeah I found it got another problem now
rektbyfaith
03-07-2021, 11:11 AM #3

Archived author: Hacki • Posted: 2021-03-07T11:11:21.707000+00:00
Original source

Hehehe yeah I found it got another problem now

rektbyfaith
Administrator
0
03-07-2021, 11:12 AM
#4
Archived author: Hacki • Posted: 2021-03-07T11:12:21.033000+00:00
Original source

after I updated the database, I now want to create something like a diff .sql. So my fix wont delete the whole db and repopulate it again but rather just updates the fields that actually have different values now... Are there tools to create such diffs automatically?
rektbyfaith
03-07-2021, 11:12 AM #4

Archived author: Hacki • Posted: 2021-03-07T11:12:21.033000+00:00
Original source

after I updated the database, I now want to create something like a diff .sql. So my fix wont delete the whole db and repopulate it again but rather just updates the fields that actually have different values now... Are there tools to create such diffs automatically?

rektbyfaith
Administrator
0
03-07-2021, 11:14 AM
#5
Archived author: Hacki • Posted: 2021-03-07T11:14:16.680000+00:00
Original source

Ahhh no nvm. Think I solved that aswell
rektbyfaith
03-07-2021, 11:14 AM #5

Archived author: Hacki • Posted: 2021-03-07T11:14:16.680000+00:00
Original source

Ahhh no nvm. Think I solved that aswell

rektbyfaith
Administrator
0
03-07-2021, 11:32 AM
#6
Archived author: Shin • Posted: 2021-03-07T11:32:25.048000+00:00
Original source

<@!425285449725116426> glad that you solved! Please read: https://www.azerothcore.org/wiki/How-to-ask-for-help
[Embed: How to ask for help]
Wiki and Documentation of AzerothCore project
https://www.azerothcore.org/wiki/How-to-ask-for-help
rektbyfaith
03-07-2021, 11:32 AM #6

Archived author: Shin • Posted: 2021-03-07T11:32:25.048000+00:00
Original source

<@!425285449725116426> glad that you solved! Please read: https://www.azerothcore.org/wiki/How-to-ask-for-help
[Embed: How to ask for help]
Wiki and Documentation of AzerothCore project
https://www.azerothcore.org/wiki/How-to-ask-for-help

rektbyfaith
Administrator
0
03-07-2021, 11:50 AM
#7
Archived author: Hacki • Posted: 2021-03-07T11:50:22.533000+00:00
Original source

Ahh yes sorry, I read it I just figured this simple question doesn't need a whole new thread. Will make one in the future
rektbyfaith
03-07-2021, 11:50 AM #7

Archived author: Hacki • Posted: 2021-03-07T11:50:22.533000+00:00
Original source

Ahh yes sorry, I read it I just figured this simple question doesn't need a whole new thread. Will make one in the future

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)