[DiscordArchive] But I need to empty or delete the teleport table?
[DiscordArchive] But I need to empty or delete the teleport table?
![[Image: image.png?ex=690beac0&is=690a9940&hm=afd...f47146f5c&]](https://cdn.discordapp.com/attachments/369084351129845760/1059447101135781968/image.png?ex=690beac0&is=690a9940&hm=afd8aee55eb0a7cf436be615b1e2a985cfffcde0318741e09830d29f47146f5c&)
Archived author: Bench • Posted: 2023-01-02T12:24:32.558000+00:00
Original source
![[Image: image.png?ex=690beac0&is=690a9940&hm=afd...f47146f5c&]](https://cdn.discordapp.com/attachments/369084351129845760/1059447101135781968/image.png?ex=690beac0&is=690a9940&hm=afd8aee55eb0a7cf436be615b1e2a985cfffcde0318741e09830d29f47146f5c&)
Archived author: Ben6777 • Posted: 2023-01-02T12:25:19.004000+00:00
Original source
INSERT INTO `game_tele` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES (1, 1054.94, 1055.23, -48.2358, 0.313367, 529, 'AB');
Archived author: Bench • Posted: 2023-01-02T12:25:54.233000+00:00
Original source
Okay, so copying the rows like that and running them as a query on your empty `game_tele` table *should* insert them fine
Archived author: Ben6777 • Posted: 2023-01-02T12:26:07.547000+00:00
Original source
ahhhhhh got it
Archived author: Ben6777 • Posted: 2023-01-02T12:39:01.483000+00:00
Original source
ok still must be doing something wrong, i can't get anything to run for my query
Archived author: Ben6777 • Posted: 2023-01-02T12:39:07.893000+00:00
Original source
nothing populates
Archived author: Bench • Posted: 2023-01-02T12:40:29.693000+00:00
Original source
Make sure to refresh, Heidi isn't very good at seeing changes automatically
Archived author: Ben6777 • Posted: 2023-01-02T12:40:35.974000+00:00
Original source
i did
Archived author: Ben6777 • Posted: 2023-01-02T12:41:08.351000+00:00
Original source
just getting errors saying some items already exist, when the table is empty