new to shell programming

bluetwist · 08-01-2005, 12:47 PM

Hi, Friends
I am a newbie for the shell programming world. I can use bash to deal with files I needed, then I need to communicate with database (MySql) based on those files in order to store some information about those files. How can I achieve this? Do I need to use other scripting language such as perl, python, or ruby etc. And how to do this in shell. Some example code will be appreciated!

Thanks for your help!

saman007uk · 08-01-2005, 12:52 PM

Look into the "mysql" command:

Code:

man mysql

bluetwist · 08-01-2005, 01:22 PM

Hi, saman007uk
Thank you for your response. Running MySql under shell is an interactive mode. I am wondering in my shell script after dealing with files, then connetc to the database and do something related to the files. How can I do this?

Thanks

saman007uk · 08-01-2005, 03:56 PM

You can generate all the SQL code in one go, put it in a file and then run as follows:

Code:

mysql databse-name << file-containg-sql-code.sql

May I recommend the following book if you are new to shell programming? Amazon: Classical Shell Scripting (the link may not work, but you can do a search in Amazon.com