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

Export database with NULL field values

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Export database with NULL field values

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • April 24, 2003 at 8:38 am #7865
      josephchoo
      Member

      Hi,

      First of all, I must compliment the author the this piece of excellent work! Thank you! 😆

      I have 2 networked computers, both installed with MySQL 4.0 and SQLyog.

      I defined and fill up a table in PC1, then export them to the database in PC2.

      When I open PC 2, I noticed that, some of the fields are filled with NULL values. This causes my .NET program reading it to fail.

      Of course, the same program reading on the PC1 (pre-export-import) is fine.

      Hope that you have time to look at it.

    • April 24, 2003 at 11:57 am #14140
      CalEvans
      Member

      Salutations!

      Add default values to the fields you are getting nulls on and re import. OR, in your programming, allow for nulls. I'm still surprised by the number of programmers who don't use null values.

      =C=

    • April 29, 2003 at 1:31 am #14141
      dfi
      Member

      I have a question for you re: your advice on changing of the default value for your column. When I export to a text file I too will get /N for some records but not all the records in the same column. As I looked back, I have char fields as well as varchar fields in my table. They definately can't be set as not null in my situation, what can I change there default value to. I have tried empty string (“” or ''), but that doesn't seem to make a difference.

      Any thoughts.

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