StevenOliver Posted April 2, 2020 Share Posted April 2, 2020 When using SSH to do a short simple mySQL select query (e.g. "select animal_name from table limit 4"), the result looks like this: | cat | | dog | | fish | | bird | Is there a way to disable the pipe "|" symbol so the result looks like this: cat dog fish bird Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/310448-ssh-mysql-without-separator/ Share on other sites More sharing options...
kicken Posted April 2, 2020 Share Posted April 2, 2020 Use the -s option: Quote -s, --silent Be more silent. Print results with a tab as separator, each row on new line. mysql -u $user -p -D $db -Nse "select blah" Quote Link to comment https://forums.phpfreaks.com/topic/310448-ssh-mysql-without-separator/#findComment-1576162 Share on other sites More sharing options...
StevenOliver Posted April 2, 2020 Author Share Posted April 2, 2020 @kicken, Thank you sir! It works wonderfully! Quote Link to comment https://forums.phpfreaks.com/topic/310448-ssh-mysql-without-separator/#findComment-1576184 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.