Can i use a string as an end of line delimeter when importing a csv to mysql?

Very basic question but im struggling with it. When i am importing a csv file to mysql is it possible to use any character or string as an end of line delimeter? If so is it possible from the admin window 'Import'? Or must i do so in a sql query (doesnt seem logical).

So far i have had issues using everything besides \n and auto in the php my admin window. I tried the € sign i tried ///. Didnt work and got errors relating to an incorrect end of line delimeter. Any help would be much appreciated. Thank you.

https://stackoverflow.com/questions/65819820/can-i-use-a-string-as-an-end-of-line-delimeter-when-importing-a-csv-to-mysql January 21, 2021 at 09:05AM