[DiscordArchive] wouldn't the WHERE come first so the query is selecting the correct <field>, and then SET <field>?
[DiscordArchive] wouldn't the WHERE come first so the query is selecting the correct <field>, and then SET <field>?
Archived author: Abillister • Posted: 2023-10-25T14:26:39.860000+00:00
Original source
I always recommend starting with a select statement. Make sure you get the results you "expect" to see before doing an update. Also, make sure you SAVE your update statement - and either add in a comment or name it something that makes sense. Because it is plausible that future 'squish' updates to AC will undo this update.
Archived author: IDUnknown • Posted: 2023-10-25T14:27:42.621000+00:00
Original source
I won't update the core for this run through, but I will save the query. Appreciate the help <@313764821776465920>
Archived author: Abillister • Posted: 2023-10-25T14:28:39.136000+00:00
Original source
And yeah that happens. Gotta be careful of the wife aggro factor.