IC Bioinfs/Project1/Code

2 FEB

• The first basic (rubbish) parser in perl, which returns a .csv of ID, size, start, end, orientation.
• A second parser, which returns a list of ID numbers only.
• A third parser, which will take forever in getting all the sequence info for each biobrick from MIT.

• INSTRUCTIONS- HOW TO UPLOAD TEXT FILE DATA INTO SQL- LINK
  • RELEVANT CODE- AFTER CREATING A DATABASE AND TABLE WITH RESPECTIVE FIELDS:
    

LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);

• • Rember- "\\" for writing the address of a file- eg. 'c:\\bla\\bla.txt';