[zenggggg]

Hello,

You can do this with Import External Data. There is an Advanced option in import external data wizard. Select the option Update with source details. Please find the screen shot attached.

Regards,

Sathish

 

 

 

It is not working, coz the columns we do not want to update got updated at the same time even do not check them in the mapping

[zenggggg]

I might be able to clarify this as I too would like to update existing records with data from a CSV file.  I only want to update certain columns though. Currently when I import external data and then tell SQLYOG to “Update with Source details” then it overwrites the data in all the columns that are not part of the CSV file.

 

Example:

 

Table: MyTable

 

Columns:  ColA,ColB,ColC

 

Existing records look like this:

 

1,a,a

2,b,b

3,c,c

 

CSV file contains:

1,d

3,e

 

I can map the first column to the primary key (ColA) and the 2nd column to the column I wish like ColC, but when I import my file all the values in ColB are replaced with NULL, since NULL is the default value on the column.

 

What I want to do is just UPDATE the records with the data from the CSV file choosing only the columns I want updated but leaving the existing data alone.

 

I see no way of doing that with SQLYOG directly.

you are right, I have the same problems too, But it is hard to believe there is no such feature in this powertool. 

[zenggggg]

I want to know how to update a table too in sqlyog 

[zenggggg]

you can do it by excel macro VBA, and schedule time in windows task scheduler. your sql code will be inside your vba code. once macro run, sql runs and auto populate the data on excel. 

[Author]

Posts