mysql> CREATE TABLE tblTEST (
-> KeyValue int(10) NOT NULL default 0,
-> DataValue varchar(255) default NULL,
-> LastEdited timestamp(14) NOT NULL,
-> PRIMARY KEY (KeyValue)
-> );
mysql> insert into tblTEST (KeyValue, DataValue) values( 1, 'Hello');
Query OK, 1 row affected (0.00 sec)
mysql> select * from tblTEST;
+----------+-----------+----------------+
| KeyValue | DataValue | LastEdited |
+----------+-----------+----------------+
| 1 | Hello | 20011214194514 |
+----------+-----------+----------------+
1 row in set (0.00 sec)
mysql> UPDATE tblTEST SET DataValue='World' WHERE KeyValue=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from tblTEST;
+----------+-----------+----------------+
| KeyValue | DataValue | LastEdited |
+----------+-----------+----------------+
| 1 | World | 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 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 PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
