MySQL||How to INSERT values into table using CASE EXPRESSION?

preview_player
Показать описание
INSERT INTO emp (id,name,department,salary)VALUES(1,'Lakshmi','Finance',
CASE
WHEN department='HR' THEN 55000
WHEN department='IT' THEN 60000
ELSE 72000
END)
Рекомендации по теме
welcome to shbcf.ru