Mysql with shell script

lijiajin · September 3, 2008, 1:08pm

Hi

did any books teaching beginner to run mysql using BASH shell?

thkx

vidyadhar85 · September 3, 2008, 1:10pm

what exactly you wanna learn??
because if you know how to connect to mysql from unix command prompt its all needed
rest is simple..

lijiajin · September 3, 2008, 1:14pm

just wanted to learn the way they code.

thkx

Ikon · September 3, 2008, 1:25pm

here is a shell script to show contents of a mysql table.

TABLE_NAME=sometable
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 $TABLE_NAME `

echo $somevar

lijiajin · September 3, 2008, 1:26pm

My fault

<< eof

eof

lijiajin · September 3, 2008, 1:27pm

ikon:

here is a shell script to show contents of a mysql table.

TABLE_NAME=sometable
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 $TABLE_NAME `

echo $somevar

Hi Ikon
Thanks for sharing