Friday, May 12, 2017

update sqlite

sqlite> select * from analysis where analysis_ID = '003327';
003327|Mapping|2017-05-05|pramod@lji@lji.org,nriley@lji.org|/mnt/overflow/NGSAnalyses/RNA-Seq/Mapping/003327_Ley_EE_samples_SR50_Combo|Ley_EE_samples_SR50_Combo|0|/mnt/Hiseq2500/170201_K00180_0308_BHGGMHBBXX_SR50_Combo

sqlite> update analysis set location="/mnt/NGSAnalyses/RNA-Seq/Mapping/003327_Ley_EE_samples_SR50_Combo" where analysis_ID='003327';
sqlite> select * from analysis where analysis_ID = '003327';
003327|Mapping|2017-05-05|pramod@lji@lji.org,nriley@lji.org|/mnt/NGSAnalyses/RNA-Seq/Mapping/003327_Ley_EE_samples_SR50_Combo|Ley_EE_samples_SR50_Combo|0|/mnt/Hiseq2500/170201_K00180_0308_BHGGMHBBXX_SR50_Combo

No comments: