DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
update if else mysql
UPDATE
prices
SET
final_price
=
CASE
WHEN
currency
=
1
THEN
0.81
*
final_price
ELSE
final_price
END
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#update
#mysql
ADD COMMENT
Topic
COMMENT
Name
7+9 =
Submit