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 1 reply thread
  • Author
    Posts
    • #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=

    • #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.

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