Forum Replies Created
-
AuthorPosts
-
Kartik GroverSpectator
Hi
The update that you want can be done by using the Import External data Tool in SQLyog. You can go to the Powertools>Import External data tool.
->This will open a window to start a new job.. Then select the type of data source (in your case it is csv) and specify the location of the a-update.csv. Click next and select the destination database.
->Then select the copy table(s) from data source. In the window that follows you will see different mapping options. Selecting the a-update.csv, and the destination as ‘Table A’.
-> Clicking on the Map tab will give the columns names i.e ‘code’ and ‘date’ In both the source and destination tables. Since you only want to update the ‘date’ column you must check the ‘date’ in source.
-> Now to give the required ‘where’ query click on the ‘Where’ tab and enter the query (in your case it would be= [`a-update`.`code`=`Table A`.`code`])
-> You can specify what to ignore and what to add while the import from the Advanced tab.
For more info on how to import you can refer..>> http://sqlyogkb.webyog.com/category/270-import-external-data
Regards
February 6, 2015 at 7:51 am in reply to: Ascii Symbols Shown In Datetime Column Values Of Mysql #35194Kartik GroverSpectatorHi
1) We are sorry but we are unable to understand the version of SQLyog that you are using.
2) There seems to be some problem with the upload of the attached screenshot of SQLyog, So please send it again.
Please provide the above information along with the dump file.
I tried to run the code given by you on version 12.07 and could not reproduce the error. I inserted some random values to check the export but there seems to be no problem with it. So any more information relevant to the issue would be a great help.
Regards
Kartik GroverSpectatorHi
Yes you have downloaded the correct SQLyog version. The reason for this is that now the documentation of SQLyog is online i.e you are directed to an online page when you go to help for the tutorial and so the size of the whole pack has reduced. Please go ahead and install it. There should be no problem.
Regards
Kartik GroverSpectatorHi
We have included clear text and dialog plugin but due to license issue we are not able to support window authentication plugin.
Regards
Kartik GroverSpectatorHi
This is a known issue and we are working on it currently. May I please know what version of SQLyog you are using.?
Regards
-
AuthorPosts