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

Evaluation Question

forums › forums › SQLyog › Using SQLyog › Evaluation Question

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • May 11, 2010 at 1:32 pm #11968
      jordanweb
      Member

      Hi, I am currently evaluation SQLyog, and I will need to transfer a lot of data from a proprietary database (using ODBC), however the Date format of the proprietary database will need to be manipulated, it is a form of Julian Date, I will need to perform some maths on the format.

      My questions, Can I manipulate the data before it is imported into MySQL, I have looked at the import wizard but cannot see a way to transform data.

    • May 12, 2010 at 4:22 am #30847
      peterlaursen
      Participant

      Yes, you can.  In the 2nd screen (I think) of the Import External Data wizard there is an option to select 'specify a query' (what will skip most GUI screens).  For instance if you have columns a, b and c on source and want to import a+b to x on target and c to y on target you specify

      SELECT a+b as x, c as y

      This is a feature that we never documented in detail (what we should).  You can ask for specific help for your case here or in a ticket if you need. But please try it with a few very simple examples yourself too.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.