Re: [Gdpdm-devel] phpMyAdmin [Terry, Isaac]
Brought to you by:
tcasstevens
From: Ken Youens-C. <kc...@cs...> - 2006-06-22 19:25:01
|
On Jun 22, 2006, at 2:19 PM, Isaak Yosief Tecle wrote: > In the new data set I am working on there are a few rice germaplasm > accessions that are already in the diversity database. I don't have > passport data different from what is in the database already for > these germplasms.So how do I deal with them in the new data set > when it comes to information (e.g. data that goes in the > div_passport table or div_locality) that needs to be stored for > them but is already in the database from previous curation. I > suppose I don't have to curate the same information again and again > for the same germplams. Right, well, this is the issue I raised with having accessions, having the ability to pin-point just which existing record you mean or defining when to create a new record. As it is, my import code looks at the entire record you're supplying and checks the table in question for a record matching it entirely; if one doesn't exist, a new record is created. So you would just need to make sure that the germplasm record in your input file matches field-by-field the data currently in the db. ky |