Upon retest, I still see the same problem. The table is created with:
CREATE TABLE User
(
iUserPK BIGINT(20) NOT NULL AUTO_INCREMENT,
cUserName CHAR(25) NULL,
cUserInitials CHAR(10) NULL,
lActive ENUM('Y','N') NULL,
lAdmin ENUM('Y','N') NULL,
tChanged TIMESTAMP(10) NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (iUserPK)
)
TYPE= InnoDB
;
INSERT INTO USER (cUserName, cUserInitials, lActive, lAdmin) VALUES ("Ted Roche", "tr", "Y", "Y") ;
correctly generates the Primary Key and tChanged Timestamp. However, when I issue:
UPDATE User SET cUserInitials = "TR" WHERE cUserName = "Ted Roche";
The initials change, the but the tChanged field does not. What am I missing?
Ted Roche, MCSE, MCSD
Ted Roche & Associates, LLC
http://www.tedroche.com