Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Odbc Update Mysql Table Using Primary Key

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Odbc Update Mysql Table Using Primary Key

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 16, 2006 at 9:42 pm #9687
      noblenull
      Member

      Navicat allows a user to Import into MySql using a Primary Key, with the option “Update: update record in destination with matching record from source”. It also does “Append/Update: If record exists in destination, update it. Otherwise Add it”.

      I can't figure out how to do these 2 functions in SQLyog using the Migration Toolkit. It seems to me I can only delete and replace, or append. Is there any way to update based on a primary key in both tables?

    • May 16, 2006 at 10:46 pm #21637
      peterlaursen
      Participant

      If I understand you right what you are requesting is behind the 'advanced' botton (for each table involved).

      SQLyog Migration tool automaticlay uses a PK to identify rows if there is a PK available.

      Please see attached. Did that answer your question?

    • May 17, 2006 at 3:24 am #21638
      Ritesh
      Member

      I am still not able to understand your problem. Can you post a screenshot or an example to explain the problem a little more?

    • May 17, 2006 at 3:39 am #21639
      peterlaursen
      Participant

      @noblenull

      Ritesh' post made me read again.

      Do you mean this situation:

      On source and target there are two rows having identical (autoincrement) PK's (say '117'), but the data are different?

      And you want the row from the source added to the MySQL database (and a new PK-value for that new row generated by the server) ?

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.