Update a column with CVS file

kaprofile5's profile image kaprofile5 posted 4 years ago in Import/Export Permalink

Hello. I am new at HeidiSQL, and can't seem to figure this one out on my own.

I want to update a whole column, with a dataset I have in an CVS file. I've tried importing it, but it doesn't seem to work. My CVS is made with Excel, and has 38,610 rows, just like my table. More specific; I want to update every number from my CVS file, so that it replaces the already existing data in the column. Is this posible?

I have attached a pic of my CVS file.

1 attachment(s):
  • heidisqlprint
ansgar's profile image ansgar posted 4 years ago Permalink

You could try out Tools > Import CSV file:

Description

kaprofile5's profile image kaprofile5 posted 4 years ago Permalink

I must have made a mistake with the control characters while importing it. Thank you so much!

Please login to leave a reply, or register at first.