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

Csv Import Converting Field To Datetime

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Csv Import Converting Field To Datetime

Tagged: , ,

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • April 1, 2013 at 6:37 am #34272
      Jan.S
      Member

      You can use LOAD LOCAL to import values from a csv file into your MySQL table if the table structure already exists. The screenshot for the same is attached.

      Import external data uses the Microsoft Text ODBC driver, and the driver returns the data as a timestamp, so there isn't anything that can be done from SQLyog to change that.

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