Feb-09-2019, 09:15 PM
hi,
I am writing a python project where i have a database table which has around 18 fields.
Now my client send me a csv with the data to be updated into the database(keeping all headers same)
now he wants me to write a query where he will send csv of those column only which has to be updated into the database, everytime there will be columns within that table but not repeating each other.
how can i update database with those columns that my client will send to me as these columns are not known to me as well. I have written my flask project which will read data from csv but how can i tell my system to read only those data?
is there any query you guys have that can help?
I am writing a python project where i have a database table which has around 18 fields.
Now my client send me a csv with the data to be updated into the database(keeping all headers same)
now he wants me to write a query where he will send csv of those column only which has to be updated into the database, everytime there will be columns within that table but not repeating each other.
how can i update database with those columns that my client will send to me as these columns are not known to me as well. I have written my flask project which will read data from csv but how can i tell my system to read only those data?
is there any query you guys have that can help?