Answer the question
In order to leave comments, you need to log in
How to implement a table in MySQL?
Let's say I have a table in excel as shown in the picture.
There is a column Sum, for which the value is calculated by the formula "=B3+B4", and the value of the column is equal for each row.
How can I make it so that there is no duplicate value for each row in the database?
An example of what it looks like in the database:
You probably ask yourself why I need this ...
I have data in Excel that I will need to display this data on the site in tables (primefaces). And to take the data should from .
Answer the question
In order to leave comments, you need to log in
Store B3 and B4 in the plate, and calculate the amount later, after filling, on the client.
Or a separate request to the database.
(Do you know what relational databases are? no? you need to read, kmk.)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question