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

How Do I Update Table ?

forums › forums › SQLyog › Using SQLyog › How Do I Update Table ?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • February 3, 2013 at 6:50 am #12915
      sanko
      Member

      I have existing data in a DB table.

      columns:

      Auto_Sl_no

      LocationName —- code —weight

      I have data in a Excel.

      columns:

      LocationName — code —weight

      I want to update code and weight in DB table from excel data for matching locations in excel and table.

      How can I do it using sqlyog ?

      (N.B: LocationName is unique)

    • February 4, 2013 at 4:59 am #34143
      sathish
      Member

      Hello,

      There is an option to map columns in import external data. You can select the particular columns that you want to import into a table. Please find the screenshot attached.

      Regards,

      Sathish

    • February 4, 2013 at 5:12 am #34144
      sathish
      Member

      You can do this directly from Powertools -> Import External Data. This feature is available only in Enterprise and Ultimate version of SQLyog.

    • February 4, 2013 at 9:55 am #34145
      sanko
      Member

      Thanks. This was very much helpful.

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