Unix Shell Script: Reading and working with MySQL Rows line by line

Question

I want a shell script (ubuntu) which fetchs data from a sql table row by row! And i want to have access on EACH row, e.g. to Check with a simple if statement, u know?

#!/bin/bash
TIME=`date +"%T"`
echo true  > log/ausgefuehrt-$TIME.log
/opt/lampp/lampp start
echo $TIME

#ASSIGNING MYSQL
MYSQL=/opt/lampp/bin/mysql
#$MYSQL -e"select * from ftp.ftp" -u root
$MYSQL -e"select * from ftp.ftp"

#STARTING TO FETCH EACH ROW (trying)
WHILE read ROW ;
        do echo $ROW # HERE <<< is the problem.. i dont know how to access each row :/
done
exit

dogbane · Accepted Answer · 2011-09-13 15:12:41Z

7

Pipe the output of mysql through a while loop as shown below:

$MYSQL -e"select * from ftp.ftp" | while IFS= read -r ROW
do
    echo "$ROW"
done

answered Sep 13, 2011 at 15:12

dogbane

276k77 gold badges407 silver badges415 bronze badges

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

Collectives™ on Stack Overflow

Unix Shell Script: Reading and working with MySQL Rows line by line

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related