[DiscordArchive] Does anyone know if there's an item mall script that's working for the current version of WotLK Trin
[DiscordArchive] Does anyone know if there's an item mall script that's working for the current version of WotLK Trin
Archived author: Jinnai • Posted: 2022-04-07T14:46:06.554000+00:00
Original source
data is contained in brackets ( )
Archived author: Jinnai • Posted: 2022-04-07T14:46:29.894000+00:00
Original source
REPLACE INTO is the sql statement you use, or the command you want to execute
Archived author: Jinnai • Posted: 2022-04-07T14:46:37.146000+00:00
Original source
you end a statement with ;
Archived author: Jinnai • Posted: 2022-04-07T14:46:45.775000+00:00
Original source
you can chain additional data with ,
Archived author: Jinnai • Posted: 2022-04-07T14:47:27.883000+00:00
Original source
point here is, only the very last line should have ; (this is how you tell "end of data for this query")
Archived author: Jinnai • Posted: 2022-04-07T14:48:10.368000+00:00
Original source
so it would be
SQL Command
VALUES
(1),
(2),
(3); <-- we end here
Archived author: Jinnai • Posted: 2022-04-07T14:48:56.270000+00:00
Original source
but since you just copied something, you already break at the very first line of data
Archived author: Birkir • Posted: 2022-04-07T14:50:18.401000+00:00
Original source
OH
Archived author: Birkir • Posted: 2022-04-07T14:50:44.808000+00:00
Original source
That's indeed what I'm missing! Didn't know that ; signifies the end of queries. Thank you so much
epeHappyFlower:867843379466862602>![[Image: unknown.png?ex=690c0d35&is=690abbb5&hm=f...19a7b4a30&]](https://cdn.discordapp.com/attachments/376457042392514560/961639373663784970/unknown.png?ex=690c0d35&is=690abbb5&hm=fd7a67daee4497bae96d2a25ad747f0bb87dce09075f759f6eec58319a7b4a30&)
Archived author: Birkir • Posted: 2022-04-07T14:51:33.208000+00:00
Original source
<
epeHappyFlower:867843379466862602>
![[Image: unknown.png?ex=690c0d35&is=690abbb5&hm=f...19a7b4a30&]](https://cdn.discordapp.com/attachments/376457042392514560/961639373663784970/unknown.png?ex=690c0d35&is=690abbb5&hm=fd7a67daee4497bae96d2a25ad747f0bb87dce09075f759f6eec58319a7b4a30&)