Python Forum
How to update sql database from csv
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to update sql database from csv
#1
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?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Get last row of SQL database and update Turtle 5 3,046 Oct-14-2021, 07:06 PM
Last Post: Turtle
Question Python + Google Sheet | Best way to update specific cells in a single Update()? Vokofe 1 2,627 Dec-16-2020, 05:26 AM
Last Post: Vokofe
Photo Update database in tkinter shahulvk 3 3,090 Oct-24-2020, 04:48 PM
Last Post: shahulvk
  add content of database to text widgte with update atlass218 1 2,553 Jan-06-2019, 02:13 AM
Last Post: woooee
  How to update only two colums in database from csv without touching data in other col Prince_Bhatia 0 2,247 Aug-21-2018, 09:13 AM
Last Post: Prince_Bhatia
  problem with select and update the data into the database chris0147 1 3,152 Aug-18-2017, 09:38 PM
Last Post: chris0147
  Search the data to update in a database chris0147 7 6,647 Oct-27-2016, 03:16 PM
Last Post: Ofnuts
  update the data into the database chris0147 3 6,161 Oct-19-2016, 12:12 AM
Last Post: Yoriz

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020