var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Hers is my full bin bash script. I only want to run the this script if their is data in my table? if not do nothing?
cat /usr/etc/extractreferral.sql | sed -e "s/file/$file/g" |/usr/bin/mysql -u root XXXXX
SELECT * INTO OUTFILE '/tmp/file'
FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' FROM Referral_Authorization
Last edited by petenyce105; 11-22-05 at 15:31.
Depending on your version of MySQL you'll most likely have to write a stored procedure in MySQL to do the data check, or write another .sql file to call a COUNT(*) on your table and have the bash script contain the "if" logic.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors