Date Problem

Hi All, I have added the date column ( column name is dolv ) in mysql as CHAR(10) as I needed the date in mmdd separated by mm/dd/. Now I want to have this column contain the date whenever the updation to that column is done. Please advise as to how I can achieve this without losing

Fwd: Mysql primary, foriegn and composite keys. Please advise

Note: forwarded message attached. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com--- Begin Message --- Hi All, I have a database consisting of 2 tables. patient_info ( Patient Information ).

Mysql primary, foriegn and composite keys

Hi All, I have a database consisting of 2 tables. patient_info ( Patient Information ).Looks like lastname VARCHAR(10) fname VARCHAR(10) ssno INT(9) PRIMARY KEY IDINT(4) AUTO_INCREMENT patientins_info ( PatientInsurance Information) insco VARCHAR(10) insid VARCHAR(10)

Re: confirm subscribe to mysql@lists.mysql.com

D list message with ALL > HEADERS intact > to make it easier to help you. > > --- Enclosed is a copy of the request I received. > > Return-Path: <[EMAIL PROTECTED]> > Received: (qmail 6846 invoked from network); 22 Jul > 2003 02:02:33 - > Received: from web14907.mail.y