[DiscordArchive] anyone know how to find and replace just the numbers in ONE column in heidisql?
[DiscordArchive] anyone know how to find and replace just the numbers in ONE column in heidisql?
Original source
anyone know how to find and replace just the numbers in ONE column in heidisql?
rektbyfaith
12-30-2023, 10:07 PM #1Archived author: Sanctuary • Posted: 2023-12-30T22:07:09.165000+00:00
Original source
anyone know how to find and replace just the numbers in ONE column in heidisql?
Original source
trying to give every item in the server that doesn't have a buy price, a buy price
rektbyfaith
12-30-2023, 10:07 PM #2Archived author: Sanctuary • Posted: 2023-12-30T22:07:43.315000+00:00
Original source
trying to give every item in the server that doesn't have a buy price, a buy price
Original source
Just make a query that takes the buy price column and swaps out 0's for whatever price u want
rektbyfaith
12-30-2023, 10:10 PM #3Archived author: Jyria • Posted: 2023-12-30T22:10:43.330000+00:00
Original source
Just make a query that takes the buy price column and swaps out 0's for whatever price u want
Original source
Should be able to find a refference online about that
rektbyfaith
12-30-2023, 10:11 PM #4Archived author: Jyria • Posted: 2023-12-30T22:11:24.647000+00:00
Original source
Should be able to find a refference online about that
Original source
UPDATE Item_template
SET buy_price = 50000
WHERE buy_price = 0;
this should work right?
rektbyfaith
12-30-2023, 10:18 PM #5Archived author: Sanctuary • Posted: 2023-12-30T22:18:04.690000+00:00
Original source
UPDATE Item_template
SET buy_price = 50000
WHERE buy_price = 0;
this should work right?
Original source
if u want to change all items sure
rektbyfaith
12-30-2023, 10:18 PM #6Archived author: Rymercyble • Posted: 2023-12-30T22:18:44.236000+00:00
Original source
if u want to change all items sure
Original source
yeah, just all items that have a 0 value in buy price
rektbyfaith
12-30-2023, 10:19 PM #7Archived author: Sanctuary • Posted: 2023-12-30T22:19:01.954000+00:00
Original source
yeah, just all items that have a 0 value in buy price
Original source
that worked, 10,980 items changed in an instant
rektbyfaith
12-30-2023, 10:22 PM #8Archived author: Sanctuary • Posted: 2023-12-30T22:22:42.897000+00:00
Original source
that worked, 10,980 items changed in an instant
1 Guest(s)
1 Guest(s)