Shell Scripting

Shell script to select and insert values from mysql.

Please support our Shell Scripting advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Mar 2009

Posts: 3

Reputation: zoollu is an unknown quantity at this point

Solved Threads: 0

zoollu

Offline

Newbie Poster

Shell script to select and insert values from mysql.

Mar 10th, 2009

Hi,

I am familiar with shell script but not really have much experience. I am looking into a shell script that would do this

I have 2 tables

TableA

id name interest
----------------------------------------
TableB

id name

I have to create a shell script which copies all the id,name values from TableA and inserts them in TableB.

Is this possible? Any help is appreciated.

thanks

•

Join Date: Aug 2007

Posts: 165

Reputation: Fest3er is an unknown quantity at this point

Solved Threads: 18

Fest3er

Offline

Junior Poster

Re: Shell script to select and insert values from mysql.

Mar 11th, 2009

•

Originally Posted by zoollu

... I have to create a shell script which copies all the id,name values from TableA and inserts them in TableB.

Is this possible? Any help is appreciated.

thanks

To misquote an old TV show, "Of course it's possible; don't be ridiculous."

And it's really trivial.

You could try something like:

Help with Code Tags

Shell Scripting Syntax (Toggle Plain Text)

mysql -u username -e 'insert into TableB select col1,col2 from TableA;'

You have to enter the password manually; if it needs to run unattended, you can include the '-p password' option on the command line.

•

Join Date: Mar 2009

Posts: 3

Reputation: zoollu is an unknown quantity at this point

Solved Threads: 0

zoollu

Offline

Newbie Poster

Re: Shell script to select and insert values from mysql.

Mar 12th, 2009

thank you I got that. its working fine. How do I check if any error occurred during execution. If an error occurred I would like to do a different operation.

•

Join Date: Aug 2007

Posts: 165

Reputation: Fest3er is an unknown quantity at this point

Solved Threads: 18

Fest3er

Offline

Junior Poster

Re: Shell script to select and insert values from mysql.

Mar 12th, 2009

•

Originally Posted by zoollu

thank you I got that. its working fine. How do I check if any error occurred during execution. If an error occurred I would like to do a different operation.

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
mysql -u ...
if [ $? -eq 0 ]; then
  echo "Success"
else
  echo "Failure"
fi
mysql -u ...
if [ $? -eq 0 ]; then
  echo "Success"
else
  echo "Failure"
fi