'^M' character at end of lines

sql unix newline line-endings os-dependent
Paul Reiners picture Paul Reiners · Sep 15, 2008 · Viewed 110.6k times · Source

When I run a particular SQL script in Unix environments, I'm am seeing a '^M' character at the end of each line of the SQL script as it is echoed to the command-line. I don't know on which OS the SQL script was originally created.

What is causing this and how do I fix it?

Answer

Thomas Owens picture Thomas Owens · Sep 15, 2008

It's caused by the DOS/Windows line-ending characters. Like Andy Whitfield said, the Unix command dos2unix will help fix the problem. If you want more information, you can read the man pages for that command.

Related questions

How do you run a single query through mysql from the command line?

I'm looking to be able to run a single query on a remote server in a scripted task. For example, intuitively, I would imagine it would go something like: mysql -uroot -p -hslavedb.mydomain.com mydb_production "select * from users;"

Read More
SqlPlus SP2-0734: Error

I am new to using SqlPlus but not new to using SQL, and I get the following error after writing this in my editor and attempting to run the script that I wrote. All of this appears to be valid …

Read More
How to convert Unix epoch time in SQLite

Could you help me convert UNIX epoch time into format yyyy-mm-dd hh:mm:ss (24h) in SQLite? (GMT+7 would be appreciated). Example: from 1319017136629 to Wednesday, October 19, 2011 4:38:56 PM GMT+7. p/s: Just looked around and found a solution: SELECT datetime(1319017136629, 'unixepoch', …

Read More