Professional Web Applications Themes

default values: can have empty string? - MySQL

when you're creating a table, can you have a column default to an empty string value (instead of NULL)? thank you......

  1. #1

    Default default values: can have empty string?


    when you're creating a table, can you have a column default to an empty
    string value (instead of NULL)?

    thank you...

    maya Guest

  2. #2

    Default Re: default values: can have empty string?

    maya wrote: 

    Yes


    Paul Guest

  3. #3

    Default Re: default values: can have empty string?

    == Quote from maya (com)'s article 

    sure thing! when specifying the column add this at the end:
    `Name` varchar(12) NOT NULL default '' or
    `Name` varchar(12) NOT NULL default ' '
    --
    POST BY: lark with PHP News Reader
    lark Guest

  4. #4

    Default Re: default values: can have empty string?

    lark wrote: 
    >
    > sure thing! when specifying the column add this at the end:
    > `Name` varchar(12) NOT NULL default '' or
    > `Name` varchar(12) NOT NULL default ' '
    > --
    > POST BY: lark with PHP News Reader[/ref]

    thank you!!! :)
    maya Guest

Similar Threads

  1. #23685 [Fbk->Csd]: fake values returned when OID value is an empty string
    By s dot zagrodzki at net dot icm dot edu dot pl in forum PHP Development
    Replies: 0
    Last Post: July 18th, 09:24 AM
  2. Replies: 2
    Last Post: July 16th, 08:58 AM
  3. #23685 [Fbk->Opn]: fake values returned when OID value is an empty string
    By s dot zagrodzki at net dot icm dot edu dot pl in forum PHP Development
    Replies: 1
    Last Post: July 16th, 07:53 AM
  4. #23685 [Opn]: fake values returned when OID value is an empty string
    By s dot zagrodzki at net dot icm dot edu dot pl in forum PHP Development
    Replies: 1
    Last Post: July 14th, 08:15 PM
  5. Replies: 0
    Last Post: July 13th, 07:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139