[DiscordArchive] Hello I want to copy all COLUMN from one table to another table in sql Table 1 = test Table 2 = test
[DiscordArchive] Hello I want to copy all COLUMN from one table to another table in sql Table 1 = test Table 2 = test
Original source
Hello I want to copy all COLUMN from one table to another table in sql Table 1 = test Table 2 = testt Can anyone help with this?
rektbyfaith
10-06-2022, 08:48 PM #1Archived author: blacknightt • Posted: 2022-10-06T20:48:21.774000+00:00
Original source
Hello I want to copy all COLUMN from one table to another table in sql Table 1 = test Table 2 = testt Can anyone help with this?
Original source
I can throw you my query for it once I get back to my computer
rektbyfaith
10-06-2022, 08:51 PM #2Archived author: Bench • Posted: 2022-10-06T20:51:27.017000+00:00
Original source
I can throw you my query for it once I get back to my computer
Original source
how long does it take?
rektbyfaith
10-06-2022, 08:59 PM #3Archived author: blacknightt • Posted: 2022-10-06T20:59:17.767000+00:00
Original source
how long does it take?
Original source
```UPDATE testt
SET COLUMN = (
SELECT COLUMN
FROM test
WHERE test.ID = testt.ID
);```
rektbyfaith
10-06-2022, 09:03 PM #4Archived author: Bench • Posted: 2022-10-06T21:03:35.684000+00:00
Original source
```UPDATE testt
SET COLUMN = (
SELECT COLUMN
FROM test
WHERE test.ID = testt.ID
);```
Original source
Uses the `ID` column to know which entry is which
rektbyfaith
10-06-2022, 09:03 PM #5Archived author: Bench • Posted: 2022-10-06T21:03:54.479000+00:00
Original source
Uses the `ID` column to know which entry is which
1 Guest(s)
1 Guest(s)