Date Problem

2003-08-14 Thread Girish Agarwal
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

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

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

2003-07-22 Thread Girish Agarwal
: from [67.34.220.53] by web14907.mail.yahoo.com via HTTP; Mon, 21 Jul 2003 19:02:23 PDT Date: Mon, 21 Jul 2003 19:02:23 -0700 (PDT) From: Girish Agarwal [EMAIL PROTECTED] Subject: How to defind and use foriegn key and composite keys To: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text

Mysql primary, foriegn and composite keys

2003-07-22 Thread Girish Agarwal
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)