mysql virtual colume alert
ALTER TABLE `user`
ADD `last name` VARCHAR(50)
AS (
case `name`
when admin then 0
else CONCAT(`name`, 'user')
end
)
;
ALTER TABLE `user`
ADD `last name` VARCHAR(50)
AS (
case `name`
when admin then 0
else CONCAT(`name`, 'user')
end
)
;