hi all,
I have a mysql database written in phpmyadmin. I have a table of clients and for each clients i would set a table of their data. In clients table I set “id” as “primary” and in data tables I have the column called id_client with foreign “id” columns in clients table.
in python I would call clients and reach the data table associate to that client
----
clients
-----
1 --> data table row with id_client = 1
2 --> data table row with id_client = 2
3 --> data table row with id_client = 3
to clarify what I would like to do: if I choose a client I would like read easily its data store in data table.
it is possible?
many thanks in advance