开发者

loading multiple line query in one row

开发者 https://www.devze.com 2023-01-02 12:10 出处:网络
How to load a multiple line query in one row using mysql.The data is stored in a text file. For example:

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

精彩评论

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