Problem with return variable in bash

Question

This mysql command line return me: count(*) 19. It's a big problem for me because I just want 19 to make a loop with this number. How can I do?

var = $(echo "select count(*) from shop_tab where catalog <> '';" | mysql -h abcdcef.com --port=3306 --user=root --password=hbbfe shop)

Try "select count(*) AS res from shop_tab where catalog <> '';" — Yasen Zhelev
– Yasen Zhelev, Commented Jul 20, 2011 at 14:44
Duplicate with : stackoverflow.com/questions/6759397/declare-variable-in-bash/… — Arnaud F.
– Arnaud F., Commented Jul 20, 2011 at 14:48

Arnaud F. · Accepted Answer · 2011-07-20 14:48:52Z

6

An easier way is :

var=$(mysql -h abcdcef.com --port=3306 --user=root --password=hbbfe --batch --skip-column-names -Dshop -e "select count(*) from shop_tab where catalog <> ''")

Moreover, I'll preconize the use of function in order to easily add options to the MySQL command without having to modifying all your script.

function MysqlQuery() {
    mysql -h abcdcef.com --port=3306 --user=root --password=hbbfe --batch --skip-column-names -D "$1" -e "$2";
}

va=$(MysqlQuery Shop "SELECT COUNT(*) FROM shop_tab WHERE catalog <> ''")
vaABC=$(MysqlQuery Shop "SELECT COUNT(*) FROM shop_tab WHERE catalog <> 'abc'")
vadef=$(MysqlQuery Shop "SELECT COUNT(*) FROM shop_tab WHERE catalog <> 'def'")
# ...

I find this more readable too...

answered Jul 20, 2011 at 14:48

Arnaud F.

8,51212 gold badges58 silver badges104 bronze badges

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

Comments

Aaron Digulla · Accepted Answer · 2011-07-20 14:47:37Z

2

Pipe the result through tail to cut off the header:

... shop | tail -1)

answered Jul 20, 2011 at 14:47

Aaron Digulla

330k111 gold badges626 silver badges840 bronze badges

Comments

gpojd · Accepted Answer · 2011-07-20 14:47:18Z

2

You can use awk or cut to get second value.

awk

var = $(echo "select count(*) from shop_tab where catalog <> '';" | mysql -h abcdcef.com --port=3306 --user=root --password=hbbfe shop | awk '{ print $2 }')

cut

var = $(echo "select count(*) from shop_tab where catalog <> '';" | mysql -h abcdcef.com --port=3306 --user=root --password=hbbfe shop | cut -d' ' -f2)

answered Jul 20, 2011 at 14:47

gpojd

23.2k8 gold badges45 silver badges71 bronze badges

Collectives™ on Stack Overflow

Problem with return variable in bash

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related