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

Importing Csv File Adding 0

forums › forums › SQLyog › Using SQLyog › Importing Csv File Adding 0

Tagged: 

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 10, 2015 at 11:21 pm #13350
      [email protected]
      Member

      I am trying to import customer data base  which include zip code. The imported data showing zip code after 0 , example original zip code is 7016, but when I imported it is showing as 07016.

       

      My import setting are attached. Please advise

       

    • April 13, 2015 at 11:12 am #35317
      peterlaursen
      Participant

      As far as I can understand this is an issue with MySQL (and the way you use it) and not with SQLyog.  You are using LOAD Data and this statement is executed on the server. It would be the same if you executedteh same LOAD DATA statement with any client.

       

      How is the column you import to defined? Execute “SHOW CREATE TABLE tablename;” and se.  iIt should not by chance be something like an INT(5) using ZEROFILL option? 

      (refer MyQL documentaton https://dev.mysql.com/doc/refman/5.5/en/numeric-type-attributes.html: ” When used in conjunction with the optional (nonstandard) attribute ZEROFILL, the default padding of spaces is replaced with zeros. For example, for a column declared as INT(4) ZEROFILL, a value of 5 is retrieved as 0005.”

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