Shell Programming and Scripting

#!/bin/bash
current_date=`date +%d-%m-%Y_%H.%M.%S`
Date=`date +%d%m%Y`
Lfriday=`date +%d%m%Y -d last-friday`
RootPath=/var/domaincount/com

mysql zonefile<<EOFMYSQL
CREATE TABLE com$Date(domain VARCHAR(255),col2 VARCHAR(255),col3 VARCHAR(255),col4 VARCHAR(255),id INT(25) NOT NULL AUTO_INCREMENT, KEY (id));
LOAD DATA INFILE '$RootPath/$today.com' INTO TABLE com$Date FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n';
delete from com$Date limit 35;
delete from com$Date order by id desc limit 2;
select count(distinct(SUBSTRING_INDEX(domain, '.',-1))) from com$Date INTO OUTFILE '$RootPath/$today.count';
select count(distinct(SUBSTRING_INDEX(a.domain, '.',-1))) from com$Date a, com$Lfriday b where a.domain=b.domain INTO OUTFILE '$RootPath/$today.overall';

#!/bin/bash
current_date=`date +%d-%m-%Y_%H.%M.%S`
Date=`date +%d%m%Y`
Lfriday=`date +%d%m%Y -d last-friday`
RootPath=/var/domaincount/com

mysql zonefile<<EOFMYSQL || echo "query failed" | sendmail 'username@where'
CREATE TABLE com$Date(domain VARCHAR(255),col2 VARCHAR(255),col3 VARCHAR(255),col4 VARCHAR(255),id INT(25) NOT NULL AUTO_INCREMENT, KEY (id));
LOAD DATA INFILE '$RootPath/$today.com' INTO TABLE com$Date FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n';
delete from com$Date limit 35;
delete from com$Date order by id desc limit 2;
select count(distinct(SUBSTRING_INDEX(domain, '.',-1))) from com$Date INTO OUTFILE '$RootPath/$today.count';
select count(distinct(SUBSTRING_INDEX(a.domain, '.',-1))) from com$Date a, com$Lfriday b where a.domain=b.domain INTO OUTFILE '$RootPath/$today.overall';
EOFMYSQL

mysql zonefile<<EOFMYSQL || echo "query failed" >> $LOG
CREATE TABLE com$Today(domain VARCHA(255),col2 VARCHAR(255),col3 VARCHAR(255),col4 VARCHAR(255),id INT(25) NOT NULL AUTO_INCREMENT, KEY (id));
LOAD DATA INFILE '$RootPath/$Today.com' INTO TABLE com$Today FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n';
delete from com$Today limit 35;
delete from com$Today order by id desc limit 2;
select count(distinct(SUBSTRING_INDEX(domain, '.',-1))) from com$Today INTO OUTFILE '$RootPath/$Today.count';
select count(distinct(SUBSTRING_INDEX(a.domain, '.',-1))) from com$Today a, com$Lfriday b where a.domain=b.domain INTO OUTFILE '$RootPath/$Today.overall';