-1

Very basic question but I'm struggling with it. When importing a .csv file to MySQL, is it possible to use any character or string as an end of line delimiter?

If so is it possible from the admin window 'Import'? Or must I do so in an 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 and also ///. Didn't work and got errors relating to an incorrect end of line delimiter.
Any help would be much appreciated. Thank you.

0

Yes, using SQL LOAD DATA .. LINES TERMINATED BY 'string'

2
  • Thank you. My only problem with this is that this requires me to open an SQL statement separately instead of having the nice "Import" tab which allows me to upload my CSV file from thte desktop . When using SQL command im forced to specify a filepath on my server it says my @localhost user's passowrd in not accepted. In the import tap I thought i could just put € after 'Lines terminated with:' in the tab but no luck. – Maximilian Travis Jan 21 at 1:59
  • "LOAD DATA LOCAL INFILE" will allow from the local machine, if the connection was started with the loaddata local option. – danblack Jan 21 at 2:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.