Re: conditional default value

2003-02-15 Thread Stefan Hinz
Tim, > I am importing text data (but in a numeric format). > The customers wants 'N/A' in an empty field. > Additionally: > The customer wishes that if a field = '' > the default value of 'N/A' be substituted. > Is this possible to do in MySQL? > Documentation? AFAIK there's no wa

Re: conditional default value

2003-02-15 Thread Paul DuBois
At 14:00 -0900 2/15/03, Tim Johnson wrote: Hello All: (using MYSQL Ver 11.15 Distrib 3.23.41 for redhat-linux-gnu (i386) (RH 7.2)) I am importing text data (but in a numeric format). The customers wants 'N/A' in an empty field. Additionally: The customer wishes that if a field = '999