[DiscordArchive] I have a quick question. I want to import this text file of realm names into the realmlist table, bu
[DiscordArchive] I have a quick question. I want to import this text file of realm names into the realmlist table, bu
Original source
I have a quick question. I want to import this text file of realm names into the realmlist table, but I want the data to import into the name column only as the id column increments. Is this possible and how would I make a query to do this?
rektbyfaith
08-08-2022, 06:26 PM #1Archived author: Deleted User • Posted: 2022-08-08T18:26:07.977000+00:00
Original source
I have a quick question. I want to import this text file of realm names into the realmlist table, but I want the data to import into the name column only as the id column increments. Is this possible and how would I make a query to do this?
Original source
https://pastebin.com/gPWfDk3Y
[Embed: Aerie PeakAgamagganAggramarAhn'QirajAl'AkirAlonsusAnachronosAratho ...]
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
https://pastebin.com/gPWfDk3Y
rektbyfaith
08-08-2022, 06:26 PM #2Archived author: Deleted User • Posted: 2022-08-08T18:26:47.446000+00:00
Original source
https://pastebin.com/gPWfDk3Y
[Embed: Aerie PeakAgamagganAggramarAhn'QirajAl'AkirAlonsusAnachronosAratho ...]
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
https://pastebin.com/gPWfDk3Y
Original source
generate INSERT INTO statements for realmlist
rektbyfaith
08-08-2022, 06:33 PM #3Archived author: ModoX • Posted: 2022-08-08T18:33:01.207000+00:00
Original source
generate INSERT INTO statements for realmlist
Original source
How would I do that? I have never built a query myself before!
rektbyfaith
08-08-2022, 06:34 PM #4Archived author: Deleted User • Posted: 2022-08-08T18:34:03.232000+00:00
Original source
How would I do that? I have never built a query myself before!
Original source
Oh I figured it out very swiftly, I just used ```LOAD DATA LOCAL INFILE 'D:/realmlist.txt' INTO TABLE realmlist;```. Thank you though.
rektbyfaith
08-08-2022, 06:34 PM #5Archived author: Deleted User • Posted: 2022-08-08T18:34:48.498000+00:00
Original source
Oh I figured it out very swiftly, I just used ```LOAD DATA LOCAL INFILE 'D:/realmlist.txt' INTO TABLE realmlist;```. Thank you though.
1 Guest(s)
1 Guest(s)