Parsing multiple lines in bash?

Question

bash

#!/bin/bash
mysql -h localhost -login -pass -Dbase -e "SELECT userID from people WHERE (login = '${LOGIN}' AND test = '${TEST}')" | while read userID; do
mysql -h localhost -login -pass -Dbase -e "DELETE from people WHERE userID = '$userID'";
done
exit

We connect to the database, see if such login and test are already in the database, delete this entry from the database.

I unfortunately do not have the opportunity to test this script. I'm concerned about the $userID variable.
BASH will understand that it needs to be taken from a mysql query?
Or maybe it's better to write such a function somehow differently?

Answer 1

What's stopping you from writing

DELETE from people WHERE (login = '${LOGIN}' AND test = '${TEST}')