loading multiple line query in one row
How to load a multiple line query in one row using mysql.The data is stored in a text file.
For example: "GGAGTTGTGGGAGTGGAGGAGGAAGAGGCGGTGGGG开发者_高级运维AGTACGGGGGCTGGTCCCAGAAGATGGCGGAGGC GGGGGATTTCTGGTAGGTCCTACTTTAGGACAAGATGTGGTGGTACTGTTGAAGCGTCAGTCTTTGATTC"Thanks in advance.
INSERT INTO dna_strands SET base_sequence = "GGAGTTG
TGGGAGTGGAGGAGGAAGAGGCGGTGGGG
AGTACGGGGGCTGGTCCCAGAAGATGGCGGAGGC
GGGGGATTTCTGGTAGGTCCTACTTTAGGACAAGATGTGG
TGGTACTGTTGAAGCGTCAGTCTTTGATTC";
As long as you're escaping the input correctly, MySQL doesn't care that the sequence of characters contains linebreaks.
精彩评论