PROTECTED]
Subject: Re: Fw: timestamp additional info
At 12:18 -0800 2001/12/14, Steve Osborne wrote:
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've tried
PROTECTED]]
Sent: Friday, December 14, 2001 1:11 PM
To: Steve Osborne
Cc: [EMAIL PROTECTED]
Subject: Re: Fw: timestamp additional info
At 12:18 -0800 2001/12/14, Steve Osborne wrote:
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've tried
passing '', NULL, and 'NULL').
Steve Osborne
Database Programmer
Chinook Multimedia Inc.
[EMAIL
mysql (filter)
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've tried
passing '', NULL, and 'NULL').
Steve
- it is always
NULL (which displays as '00').
HTH,
--
coop
On Fri, 2001-12-14 at 15:16, Steve Osborne wrote:
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want
You are inserting the string 'NULL'
Don't include it at all in the insert.
Steve Osborne wrote:
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've
| 20011214194555 |
+--+---++
1 row in set (0.00 sec)
mysql
Regards
M
-Original Message-
From: Steve Osborne [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 20:16
To: MySQL (E-mail)
Subject: timestamp additional info
Timestamp additional info:
INSERT
Thanks, it is working perfectly as described
Steve
Don't reference the timestamp column at all in your INSERT (or future
UPDATE) statements and the timestamp should update just fine on its own.
i.e.
INSERT INTO Owners (NameID,ProductsKey,RegNum)
VALUES ('$NameID','1','$RegNumc');
At 12:18 -0800 2001/12/14, Steve Osborne wrote:
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've tried
passing '', NULL, and 'NULL').
Steve
Hi