All pastes #243403 Raw Edit

Divers

public text v1 · immutable

·published 2006-11-08 12:43 UTC

Problem with passing variables to command, i guess it's a quote issue

It works :
mysql -h localhost -u root -D bddlog -e 'SELECT * FROM 11_NOVEMBRE WHERE dateJour < CURDATE() - INTERVAL 3 DAY'
mysql -h localhost -u root -D bddlog -e "SELECT * FROM 11_NOVEMBRE WHERE dateJour < CURDATE() - INTERVAL 3 DAY"

I try to put that in a variable:
COMMAND='mysql -h localhost -u root -D bddlog -e "SELECT * FROM 11_NOVEMBRE WHERE dateJour < CURDATE() - INTERVAL 3 DAY"'
COMMAND="mysql -h localhost -u root -D bddlog -e 'SELECT * FROM 11_NOVEMBRE WHERE dateJour < CURDATE() - INTERVAL 3 DAY'"
COMMAND="mysql -h localhost -u root -D bddlog -e 'SELECT "*" FROM 11_NOVEMBRE WHERE dateJour < CURDATE() - INTERVAL 3 DAY'"

Each time, the * is replaced by all files in the current directory
How avoid that ?