conditional default value

2003-02-15 Thread Tim Johnson
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 = '' the default value of 'N/A' be

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 =

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 way to