mysql: get value of table row in bash

Question

When I run this command I get a full table output....

mysql --user=root --password="mypassword" -e "SELECT btce_last_price FROM api.btc WHERE id=1"


+-----------------+
| btce_last_price |
+-----------------+
|             723 |
+-----------------+

I would like the output to be just "723".

Try adding --skip-column-names

juergen d
– juergen d

2014-01-01 21:22:11 +00:00
Commented Jan 1, 2014 at 21:22 — juergen d
– juergen d, Commented Jan 1, 2014 at 21:22
This gives me. +-----+ | 723 | +-----+

nyitguy
– nyitguy

2014-01-01 21:37:10 +00:00
Commented Jan 1, 2014 at 21:37 — nyitguy
– nyitguy, Commented Jan 1, 2014 at 21:37
SOLVED adding "-s --skip-column-names"

nyitguy
– nyitguy

2014-01-01 22:43:13 +00:00
Commented Jan 1, 2014 at 22:43 — nyitguy
– nyitguy, Commented Jan 1, 2014 at 22:43

juergen d · Accepted Answer · 2014-01-02 00:28:48Z

6

Use the silent mode -s to produce less output. You can also add raw -r and --skip-column-names

edited Jan 2, 2014 at 0:28

answered Jan 1, 2014 at 21:48

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

3 Comments

nyitguy Over a year ago

-s helps....I had to add grep to ignore tablename... mysql --user=root --password="mypassword" -e "SELECT btce_last_price FROM api.btc WHERE id=1" -s |grep -v btce_last_price.

nyitguy Over a year ago

or adding "head -1" to remove first line output.

nyitguy Over a year ago

SOLVED... "-s --skip-column-names"

georgepsarakis · Accepted Answer · 2014-01-02 10:15:13Z

1

The -N switch removes column names and you can use awk to strip the tabular formatting (whitespace, pipe & dash symbols):

SQL='SELECT btce_last_price FROM api.btc WHERE id=1'
mysql -u root -p "mypassword" -N -e "$SQL"|awk '{print $1}'

answered Jan 2, 2014 at 10:15

georgepsarakis

1,9574 gold badges21 silver badges24 bronze badges

Comments

Damien Black · Accepted Answer · 2014-01-01 21:49:54Z

0

Try

mysql --user=root --password="mypassword" -e "SELECT btce_last_price FROM api.btc WHERE id=1" | tr -dc '[0-9]'

That'll get you your bitcoin prices by pulling out only the numbers from that output.

If you aren't just looking for numbers, you can use

mysql --user=root --password="mypassword" --skip-column-names -e "SELECT btce_last_price FROM api.btc WHERE id=1"  | tr -d '[\+\-\| ]'

As long as there aren't and +, -, | or spaces in your value... otherwise you have to get trickier.

edited Jan 1, 2014 at 21:49

answered Jan 1, 2014 at 21:14

Damien Black

5,65720 silver badges25 bronze badges

2 Comments

nyitguy Over a year ago

This works but not all values are numbers. How about if the value is "abc4329480_+908902"

nyitguy Over a year ago

This works for my requirements at this time. But I thought it should be easier to get any value. I tried to +1 but don't have enough rep yet.

Collectives™ on Stack Overflow

mysql: get value of table row in bash

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related