--- [EMAIL PROTECTED] wrote: > Hi! This is the ezmlm program. I'm managing the > [EMAIL PROTECTED] mailing list. > > I'm working for my owner, who can be reached > at [EMAIL PROTECTED] > > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please send > an empty reply to this address: > > > [EMAIL PROTECTED] > > Usually, this happens when you just hit the "reply" > button. > If this does not work, simply copy the address and > paste it into > the "To:" field of a new message. > > or click here: > > mailto:[EMAIL PROTECTED] > > This confirmation serves two purposes. First, it > verifies that I am able > to get mail through to you. Second, it protects you > in case someone > forges a subscription request in your name. > > Some mail programs are broken and cannot handle long > addresses. If you > cannot reply to this request, instead send a message > to > <[EMAIL PROTECTED]> and put the > entire address listed above into the "Subject:" > line. > > > --- Administrative commands for the mysql list --- > > I can handle administrative requests automatically. > Please > do not send them to the list address! Instead, send > your message to the correct command address: > > For help and a description of available commands, > send a message to: > <[EMAIL PROTECTED]> > > To subscribe to the list, send a message to: > <[EMAIL PROTECTED]> > > To remove your address from the list, just send a > message to > the address in the ``List-Unsubscribe'' header of > any list > message. If you haven't changed addresses since > subscribing, > you can also send a message to: > <[EMAIL PROTECTED]> > > or for the digest to: > <[EMAIL PROTECTED]> > > For addition or removal of addresses, I'll send a > confirmation > message to that address. When you receive it, simply > reply to it > to complete the transaction. > > If you need to get in touch with the human owner of > this list, > please send a message to: > > <[EMAIL PROTECTED]> > > Please include a FORWARDED 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 -0000 > Received: from web14907.mail.yahoo.com (HELO > web14907.mail.yahoo.com) (216.136.225.59) by > lists.mysql.com (qpsmtpd/0.26-dev) with SMTP; Tue, > 22 Jul 2003 04:02:32 +0200 > Message-ID: > <[EMAIL PROTECTED]> > Received: 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/plain; charset=us-ascii > X-Spam-Check-By: lists.mysql.com > X-Spam: False ; 0.0 / 5.0 > > 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 > ID INT(4) AUTO_INCREMENT > > patientins_info ( PatientInsurance Information) > > insco VARCHAR(10) > insid VARCHAR(10) > > I want to create chart number based on :- > 2 characters of (lastname)+2characters of > (fname)+(ID) > ( So according to my understanding I will have to > generate some kind of composite key ). > > Also, this chart number will be my primary key in > all > patient insurance database. Since I am fairly new in > database area, I don't know much but I think I will > have to define some kind of references/foriegn key > relations. My database type is MyISAM. > > Please advise. > > Thanks, > Girish > > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site > design software > http://sitebuilder.yahoo.com
__________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
