Re: [wdvltalk] Help with MySQL database design and operation

2008-08-12 Thread Matthew Macdonald-Wallace
Quoting Ross Clutterbuck <[EMAIL PROTECTED]>: > Thanks Matthews > > Yahoo's no longer letting me send via their SMTP servers so until > recently I've not been able to actually communicate with the list - > not that I've been able to help much recently anyway! I'm all fully > moved to GMail now so

Re: [wdvltalk] Help with MySQL database design and operation

2008-08-12 Thread Ross Clutterbuck
Thanks Matthews Yahoo's no longer letting me send via their SMTP servers so until recently I've not been able to actually communicate with the list - not that I've been able to help much recently anyway! I'm all fully moved to GMail now so that's one less thing to worry about. Let me go over this

Re: [wdvltalk] Help with MySQL database design and operation

2008-08-12 Thread Matthew Macdonald-Wallace
Quoting Ross Clutterbuck <[EMAIL PROTECTED]>: The main operation I need a hand with is deleting units from the units table. Obviously, if I delete a unit I want it removed from all qualifications that use it automatically. With that in mind, again, is a comma-delimited list of unit IDs in qualifi

Re: [wdvltalk] Help with MySQL database design and operation

2008-08-12 Thread Matthew Macdonald-Wallace
Quoting Ross Clutterbuck <[EMAIL PROTECTED]>: > Hi List - been a while. Indeed, I was wondering where "MoU" had got too... :oP > > In a nutshell my knowledge of database design and operation is very > basic so I come to you for some advice on how best to set up a simple > database and how to car

[wdvltalk] Help with MySQL database design and operation

2008-08-11 Thread Ross Clutterbuck
Hi List - been a while. In a nutshell my knowledge of database design and operation is very basic so I come to you for some advice on how best to set up a simple database and how to carry out certain operations on it. What I want to achieve is a database of qualifications that a user can sea