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
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 =
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