ESC" as delimiter in File insertion for MYSQL

Discussion in 'MySQL' started by hzzg6y, Nov 10, 2011.

0
  1. #1
    I need help on loading the text file having "ESC" as delimiter ( Octal \003). This file I need to load in MY SQL however I don't know what should be query to insert such file with "ESC" as delimiter. Please help.
     
    hzzg6y, Nov 10, 2011 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    1) \003 isn't Esc, it's ETX, end of text.

    2) How are you planning to load it? What program are you going to use? That will determine what to do with the ETX.
     
    Rukbat, Nov 15, 2011 IP