MYSQL differs in Output from script

Question

I have a problem with the MySQL output formatting while executing the commands from a bash script.

If I execute a command on the command line then, I am able to get the output in formatted as expected.

$ mysql -u dbclient -pxxxx GEKONYLOGDB -e "select now(),max(time_stamp) from metrics"
+---------------------+---------------------+
| now()               | max(time_stamp)     |
+---------------------+---------------------+
| 2012-12-09 14:25:38 | 2012-12-09 14:25:20 |
+---------------------+---------------------+

But where as if I keep the same command in a script and execute I am not getting the formatted output.

$ cat test
#!/bin/bash
mysql -u dbclient -pxxxx GEKONYLOGDB -e "select now(),max(time_stamp) from metrics"

$ ./test
now()   max(time_stamp)
2012-12-09 14:27:52     2012-12-09 14:27:47

So all I need the same output from script.

Thanks.

Michael Berkowski · Accepted Answer · 2017-04-25 13:24:04Z

13

Pass the -t or --table option to force table output.

mysql --table -u dbclient -pxxxx GEKONYLOGDB -e "select now(),max(time_stamp) from metrics"

From mysql --help:

  -t, --table         Output in table format.

edited Apr 25, 2017 at 13:24

answered Dec 9, 2012 at 19:34

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sriharsha Kalluru Over a year ago

Thank you very much, It is working and giving the expected output.

Robert Lujo · Accepted Answer · 2019-10-15 13:04:20Z

0

If you want to have --table option enabled by default when calling mysql program, please check this SO answer How to store MySQL results to a file in table format.

answered Oct 15, 2019 at 13:04

Robert Lujo

16.6k6 gold badges60 silver badges77 bronze badges

Collectives™ on Stack Overflow

MYSQL differs in Output from script

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related