Sorry to post this here
How do I write a query to double the `buyprice` of every item that costs less than 20US.
Can someone help me with this please.
I had
UPDATE Account
SET buyprice
This is where i got stuck been searching google but couldnt find it
I don't know if this will work for you or not, but here is a suggestion
update account
set byprice = byprice * 2
where byprice < 20
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.