[DiscordArchive] <@203326888888893440> While i've figuredo ut how to change the table and add new column with the dat
[DiscordArchive] <@203326888888893440> While i've figuredo ut how to change the table and add new column with the dat
Original source
<@203326888888893440> While i've figuredo ut how to change the table and add new column with the data and "settings" do you know how to re-order the columns?
rektbyfaith
11-07-2024, 11:59 PM #1Archived author: Ryan Turner • Posted: 2024-11-07T23:59:07.890000+00:00
Original source
<@203326888888893440> While i've figuredo ut how to change the table and add new column with the data and "settings" do you know how to re-order the columns?
Original source
Original
Column A and Column B, not has C and D also, is there anyway to place C between A and B?
rektbyfaith
11-07-2024, 11:59 PM #2Archived author: Ryan Turner • Posted: 2024-11-07T23:59:27.421000+00:00
Original source
Original
Column A and Column B, not has C and D also, is there anyway to place C between A and B?
Original source
I figured it out!
rektbyfaith
11-08-2024, 12:10 AM #3Archived author: Ryan Turner • Posted: 2024-11-08T00:10:27.502000+00:00
Original source
I figured it out!
Original source
```sql
ALTER TABLE `player_factionchange_achievement_copy`
ADD `alliance_comment` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `alliance_id`,
ADD `horde_comment` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `horde_id`;
```
rektbyfaith
11-08-2024, 12:10 AM #4Archived author: Ryan Turner • Posted: 2024-11-08T00:10:47.291000+00:00
Original source
```sql
ALTER TABLE `player_factionchange_achievement_copy`
ADD `alliance_comment` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `alliance_id`,
ADD `horde_comment` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `horde_id`;
```
Original source
Ended up figuring out out to its better to drop and create a new one one
rektbyfaith
11-08-2024, 02:34 AM #5Archived author: Ryan Turner • Posted: 2024-11-08T02:34:54.797000+00:00
Original source
Ended up figuring out out to its better to drop and create a new one one
Original source
Well you could also add columns and use update queries to add the comments
rektbyfaith
11-08-2024, 05:05 AM #6Archived author: sudlud • Posted: 2024-11-08T05:05:31.454000+00:00
Original source
Well you could also add columns and use update queries to add the comments