开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜