how to create a calculated column
0
votes
1
answer
4587
views
I want to create a table, this table's name is "Prod", in his table, I have the:
**ID**, **name**, **Buying_price** and **selling_price**
when the user inserts the data, I want him to enter "name, and buying_price" and I'd like the column of **selling_price** to be calculated depending on the user's input by this method (buying_price + 20% Buying_price)
I don't know how to do this, I thought that a function/procedure could help but I have no idea how to do it, since I am new to database and SQL I would so much appreciate any help
Asked by kylie
(39 rep)
Jan 4, 2023, 07:26 PM
Last activity: Jan 4, 2023, 08:55 PM
Last activity: Jan 4, 2023, 08:55 PM