How to interpret mysql output in shell script?

Question

What I try:

player=tester111

id=$(mysql -h "127.0.0.1" -u "myuser" -ppassword "database" -e \
  "SELECT id FROM login WHERE name='$player';")

echo $id

The following output appears:

id 223

How to get ONLY 223 as output?

I am new to stackoverflow, feel free to comment so I can improve my asking skills.

Rahul · Accepted Answer · 2017-06-22 20:20:46Z

3

Use the -N switch when executing your query. -N is for skipping column name and thus you will get only values returned (that is 223 returned) like

id=$(mysql -N -h "127.0.0.1" -u "myuser" -ppassword "database" -e \
  "SELECT id FROM login WHERE name='$player';")

answered Jun 22, 2017 at 20:20

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

1 Comment

realKSMC Over a year ago

Epic! Thx alot :)

Collectives™ on Stack Overflow

How to interpret mysql output in shell script?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related