On 8 Feb 2003, at 12:25, Bhavin Vyas wrote:
> So, it could either be ^www.yahoo.com^(ct value) or
> .^^.(no ct value). I would like that when there is no
> ct value present in the line, the ct value in Log table should
> stay as the default NULLbut it is not. The value becomes ''
Bhavin,
the documentation says that you use \N to represent null values.
Keith
Extranet
[EMAIL PROTECTED] - 08/02/2003 17:25
To:mysql
cc:
Subject:Help with default NULL
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field
While exporting the data can you map empty strings to the literal null?
-Original Message-
From: Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 11:25 AM
To: [EMAIL PROTECTED]
Subject: Help with default NULL
Hi,
I have a table Log described as such
At 12:32 -0500 2/7/03, Bhavin Vyas wrote:
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL| |
| time | int(10) | |
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL| |
| time | int(10) | |
