IC Bioinfs/Project1/Code

From OpenWetWare

Jump to: navigation, search

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';
Personal tools