Thursday, October 7, 2010

Shell Scripts to run MySQL Query

 DB_NAME=SomeDB USER_NAME=someuser IP_ADDR=localhost PASSWORD=somepassword  somevar=`echo "select * from <table_name> where <condition>" | mysql -h $IP_ADDR -u$USER_NAME -p$PASSWD $DB_NAME `  echo $somevar

No comments:

Post a Comment