Hi… I’m learning SQL right now… (learning by doing) And my goal is to generate a Primary Key which should be insert in the Column “ID”.
But my Main-Problem is to generate it, becouse:
It should be generatted out of other columns in the row to prevent multiple entries for the same “state” of row…
Like this:
| ID | column1 | column2 | column 3 |
---------------------------------
| 01 | Text1 | 05 | 3.04 |
| 02 | Text2 | 06 | 3.04 |
| 03 | Text1 | 05 | 5.10 |
| 01 | Text1 | 05 | 3.04 | -> “OH… This is the same as the first entry. I dont add this!”
-----------------------------------
So I want to calculate the ID from the contents of the columns 1 to 3
Is that possible in any way?