IC Bioinfs/Project1/Code
From OpenWetWare
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:
- 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';