Inserting data 1

[JohnLucania]

How do you parse the data (Seq.txt) into a table in mysql?

The txt data look like:
>AREDD7|Mus musculus|brain|45545|411|741
aagcggccggtctgcagtcggagacttgcaggcagcaaacacggtgcgaacgaaccggag
gggggagagagaaatcaaacagctaagcgtggagcagacggcctgggacccagaagggga
tcgatgcgaggagcgcaataata
>RTAAD|Bacteria|Pro|122|3212129|204340
aagcggccggtctgcagtcggagacttgcaggcagcaaacacggtgcgaacgaaccggag
gggggagagagaaatcaaacagctaagcgtggagcagacggcctgggacccagaagggga
tcgatgcgaggagcgcaataata
> bla........
aaagaga
>bla ........

There are 8 corresponding fields in the table. The first field is Auto-increment ID.

jl

 

[PaulTEG]

John, this isn't a problem, if it was a problem we could help ... it's who we are

First point in problem solution is statement of problem ...
Does it always start with >


Spend an hour a week on CPAN, helps cure all known programming ailments ;-)