IC Bioinfs/Project1/Code

2 FEB

 * The first basic (rubbish) [[Media:perlparse.txt|parser]] in perl, which returns a .csv of ID, size, start, end, orientation.
 * A [[Media:partslist.txt|second]] parser, which returns a list of ID numbers only.
 * A [[Media:seq_pl.txt|third]] parser, which will take forever in getting all the sequence info for each biobrick from MIT.

LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);
 * INSTRUCTIONS- HOW TO UPLOAD TEXT FILE DATA INTO SQL- LINK
 * RELEVANT CODE- AFTER CREATING A DATABASE AND TABLE WITH RESPECTIVE FIELDS:
 * Rember- "\\" for writing the address of a file- eg. 'c:\\bla\\bla.txt';