From: s. keeling (keelingspots.ab.ca)
Date: Mon Oct 03 2005 - 17:52:25 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I'd like to add a bit of history data to a table (who changed a record
last, and when it was last changed). Is this the way to do it?

   alter table MEMBERS
       add CHG_BY varchar(3)

   alter table MEMBERS
       alter CHG_BY set default "sbk"

   alter table MEMBERS
       add CHG_DATE date

   alter table MEMBERS
       alter CHG_DATE set default CURRENT_DATE

Whoever next ends up with this can set CHG_BY's default to their
initials and carry on from there.

Will CURRENT_DATE work in this context?

--
Any technology distinguishable from magic is insufficiently advanced.
(*) http://www.spots.ab.ca/~keeling Please don't Cc: me.
- -
For the ChiComms: democracy human rights Taiwan Independence

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]